5/6/2004 01:00:00.000
??? dst issue?
anyway, THANKS MAJORLY FOR YOUR HELP!!!!!!
i got that shite down to like 5 min, vs. 4 hrs!!!!!!!!!!!!
later.
tw
On Thu, 5 Aug 2004 14:40:00 -0400, DURETTE, STEVEN J (AIT)
<[EMAIL PROTECTED]> wrote:
> Tony,
>
> 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]
