help with sql command--quickie hopefully

[cj]

I have a sql db table with a field of type DATETIME.

I want to do something like this:

select * from calls where timestamp > date("6/7/2007 7:00")

problem is date only works with a date with out the time. How can I get
the time in?

 

[PlatinumBay]

cj,

You should post this in the SQL Server forum. I'll take a stab though.

Check out this article, specifically the CONVERT function.
http://sqljunkies.com/HowTo/6676BEAE-1967-402D-9578-9A1C7FD826E5.scuk

You can also just use the following syntax:
SELECT * FROM Table1
WHERE (dt > '6/9/2007 01:43:21')

Hope this helps,


Steve

 

[WenYuan Wang [MSFT]]

Hello CJ,
Thanks for Steve's reply.

I agree with Steve. I think it should work fine.
SELECT * FROM Table1 WHERE (dt > '6/9/2007 01:43:21')
Do you meet any further issue?

Hope this will help.
Wen Yuan
Microsoft Online Community Support
==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.

 

[cj]

Actually I figured this out with help from another forum. The SQL
command I needed apparently is specific to the Informix database I was
connecting to.

select * from calls where timestamp > '2007-06-07 19:48:58'

unlike sql server it doesn't take am/pm. It needs 24 hr format. I also
needs - instead of / and year first. That kind of formatting issue is
apparently all it took.

Thanks for the help.

 

[WenYuan Wang [MSFT]]

Hello CJ
Thanks for your information.

I'm glad to hear you have resolved the issue.

Have a nice day,
Sincerely,
Wen Yuan
Microsoft Online Community Support
==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.