If you are just looking for the date, why don't you do:
select dateAdd(d, -91, convert(varchar, getdate(), 101))
That returns 5/6/2004 00:00:00.000
Steve
-----Original Message-----
From: Tony Weeg [mailto:[EMAIL PROTECTED]
Sent: Thursday, August 05, 2004 2:08 PM
To: CF-Talk
Subject: sql question (Quick and easy)
hi there...
this query below returns an epoch time, something like 1083851729
select dateDiff(ss,'01/01/1970 00:00:00.000',DATEADD(Day, -91, GetDate()))
which is GREAT, and translates into: 05/06/2004 14:55:29
but....
i need to get: 05/06/2004 00:00:00.000
i can do it all day long in cfml, but i need to do it in sql code.
any ideas?
thanks.
here is my first attempt...but obviously...it gave me an error:
select
dateDiff(ss,'01/01/1970 00:00:00.000',DATEADD(Day, -91, day(getDate())))
any help, as always is MUCH Appreciated.
--
tony
Tony Weeg
human.
email: tonyweeg [at] gmail [dot] com
blog: http://www.revolutionwebdesign.com/blog/
Check out http://www.antiwrap.com to send websites to your friends.
_____
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
