Regarding Select statement ........

[shadow]

Hi All,

I want to populate the data between these two Dates and times.(13th oct 8'o'clock and 13 nov 8'o'clock). Could you give me any one syntax for this select statement.

Thanks & Regards,

SHAIK JAILABDIN.

[vinod_vemuru2]

Hi,

Which table you are trying to access? That table should have creation date and time fields or timestamp field.

In where clause use GE lower limits and LE upper limits.

Thanks,

Vinod.

[Former Member]

Hi

If the table has not a field timestamp, i.e the field for data and the field for time are distinct, I believe u need to do the select in 2 different steps:

The first one u select all record between 13th oct and 13th nov,

The second one: u delete all records of 13th oct with time less the 8'o'clock and 13th nov with time > 8 o'clock

SELECT * FROM <TABLE> WHERE DATE => '200911013' AND DATE =< '20091113'.
   IF ( <TABLE>-DATE = '20091013' AND <TABLE>-TIME < '080000' ) OR.
      ( <TABLE>-DATE = '20091113' AND <TABLE>-TIME > '080000' ).

" Do nothing
  ELSE.
" Do something   
  ENDIF.
ENDSELECT.

Max

[shadow]

THANk's.