hi,guys ,pls help..

How to select by  date(+30 Seconds)


Regards
Garey

Garey


I had written an answer but then I came up with a few other scenarios as to what you were trying to achieve and realised I didn't know just what you need help with.

Date + 30 seconds means a TIMESTAMP so are you selecting against a timestamp field and you want everything after a certain day or.....

To add 30 seconds to the current date in sql try

CAST(CAST(CURRENT_DATE AS CHAR(10)) +' 00:00:30.00' AS TIMESTAMP)

Roy Lambert [Team Elevate]

Roy Lambert wrote:

Garey


I had written an answer but then I came up with a few other scenarios as to what you were trying to achieve and realised I didn't know just what you need help
with.

Date + 30 seconds means a TIMESTAMP so are you selecting against a timestamp field and you want everything after a certain day or.....

To add 30 seconds to the current date in sql try

CAST(CAST(CURRENT_DATE AS CHAR(10)) +' 00:00:30.00' AS TIMESTAMP)

Roy Lambert [Team Elevate]


hi Roy,many many thank...

> CAST(CAST(CURRENT_DATE AS CHAR(10)) +' 00:00:30.00' AS TIMESTAMP)

or

cast(current_date as timestamp)+30000   


John

John


I can never remember which uses milliseconds past midnight and which a fraction of a 24 hour day (I think this is TDateTime) so I'm playing safe.

Roy Lambert