I need to specify a date value in a sybase where clause. For example:
select * from data where dateVal < [THE DATE]
Use the convert function, for example:
select * from data where dateVal < convert(datetime, '01/01/2008', 103)
Where the convert style (103) determines the date format to use.
1.4m articles
1.4m replys
5 comments
56.9k users