Correct syntax for datetime

[Ogi]

Hi,

Can anyone help with the following SQL command:-

Select * From [TimeSheet Records] Where [Record Identity] = 27/12/2001 12:00:30

I've got a datetime field that contains the above data but can't get it!

I'm using VB and SQL 2000 Personal, if that helps!

Cheers,
Ogi.

 

[fluteplr]

Select * From [TimeSheet Records] Where [Record Identity] = '2001-12-27 12:00:30'

 

[needsOLTPadvice]

Hi Ogi,
Try DateValue function. It works in MS SQL Jet run agains MS Access Database. Like this:
Select * From [TimeSheet Records] Where [Record Identity] = DateValue('2001-12-27 12:00:30')

 

[Ogi]

Hi,

Thanks, will try that now!

Regards,
Ogi.

 

[Ogi]

Hi,

Well Fluteplr, 10 out of 10....worked first time, just need to reformat my date now!!!!

Cheers guys,
Ogi.

PS Not dismissing yours needsOLTPadvice