Getting only todat's date value from database

[ajaykumar1]

Hi Everyone,

I have the fields like below.

WHAT	STATE	STARTED	FINISHED
First Job	Ready	10/29/2015 9:01	10/29/2015 9:01
First Job	Ready	10/28/2015 8:01	10/28/2015 8:40
First Job	Ready	10/27/2015 8:01	10/27/2015 8:28
First Job	Ready	10/25/2015 7:16	10/25/2015 7:35
First Job	Ready	10/23/2015 10:01	10/23/2015 10:48
First Job	Not Ready	10/29/2015 9:00	10/29/2015 9:01
First Job	Process	10/29/2015 9:00	10/29/2015 9:01
First Job	Middle	10/29/2015 9:00	10/29/2015 9:01

My conditions when am getting the data from the data base is;

What = 'First Job' and State = Ready and Started = todaysdate

With that above sample data then 0 records should come .But after if i run this extractor after some time

If my 'Started' have todays time stamp(i.e. e.g 10/30/2015 10.15) then i need to get those records.

I hope my requirement is clear.

Thanks,

Ajay

[avinashelite]

what is your back end database?? if you can specific that we will able to give the exact solution

[ajaykumar1]

My backend data base is oracle.

[Anonymous]

then try with CurDate() (

load ...

from xyz

where (What='First Job') and (State='Ready') and (date#(Started,'DD/MM/YYYY')=CURDATE())

Oracle Spec

Table 12.13 Date/Time Functions

Name	Description
ADDDATE()	Add time values (intervals) to a date value
ADDTIME()	Add time
CONVERT_TZ()	Convert from one timezone to another
CURDATE()	Return the current date

[ajaykumar1]

Hi All,

I have tried all those things like systime,curdate() and today() and etc..

But am unable to get the positive reslut...Getting the proper with with whatever the same data which i provided earlier with same time stamp...thats good.

Thanks for all your patience support for my small work.:-)

Ajay

[maxgro]

in Oracle use

SYSDATE                    --> 30/10/2015 13:45:58

or trunc(SYSDATE)    --> 30/10/2015

an example, adapt to your req

load

     .....

     ;

SQL

SELECT

     .........

WHERE STARTED >= SYSDATE;

[vishsaggi]

Hello AJay,

Probably first get the data from Oracle and load into a temp table and

do a resident load as given by Rudolf. Did you try that resident load???

V.

[tschullo]

WHERE DATE(STARTED) = Today();