datetime using sql problem - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Development (2000)

datetime using sql problem

Author

Topic

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2001-12-06 : 10:06:30

Stuart writes "I am using sqlserver 6.5.
My problem is that I cannot pull out a datetime field using sql.
example:

SELECT *
FROM mytable
WHERE OrderDate = '01/12/2001'

This date is in the field orderdate but comes with no records in the result sql query tool.

This is in UK date format and it is also stored as UK format when looking at the results for selecting * from the table.

Thanks in advance for any pointers you can give me,
Stuart"

Nazim
A custom title

1408 Posts

Posted - 2001-12-06 : 10:31:52

SELECT *
FROM mytable
WHERE OrderDate = '01/Dec/2001'

i think sql takes '01/12/2001' this as(01-Jan-2001) , u can check convert function too.
-------------------------
Nazim -- "Success is when Preparedness meets Opportunity"

Edited by - sdnazim on 12/06/2001 10:38:35

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources