Date Conversion in T-SQL -Immediate help needed!!!
Posted on 2001-08-29
This should be an easy question - but I need immediate help...
Here is the logic behind piece of SQL I am trying to run in SQL7
WHERE TRUNC(ExportTimeStamp) = '01/01/2001'
Well TRUNC is a command in ORACLE that strips the time part of the argument. Of course there is no TRUNC command in SQL7. How do people do this in T-SQL??
is there some kind of TO_DATE or FORMAT function I can use on the date? i.e:
WHERE Format(ExportTimeStamp, 'yyyymmdd') = '20010101'
Thanks for your help