topic Regarding Select statement ........ in Application Development and Automation Discussions

Regarding Select statement ........

shadow — Mon, 16 Nov 2009 15:17:31 GMT

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.

Re: Regarding Select statement ........

vinod_vemuru2 — Mon, 16 Nov 2009 15:21:50 GMT

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.

Re: Regarding Select statement ........

Former Member — Mon, 16 Nov 2009 15:27:45 GMT

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

Re: Regarding Select statement ........

shadow — Tue, 02 Feb 2010 04:16:03 GMT

THANk's.