anataliocs
10/23/2013 - 7:00 PM

SQL date conversions date range

SQL date conversions date range

dates.txt
content_copyfile_download
WHERE DATE BETWEEN '09/16/2010 05:00:00' and '09/21/2010 09:00:00'

Convert SQL Server timestamp into date
CONVERT(char(10), Dateadd(second, (createStamp/1000), '01/01/1970'), 101) as Created