Adjusting a timestamp

Dorothy,

It would be easier to read your code if you used ASNI SQL JOIN instead of
the old fashion "JOIN in the where clause" style; anyway,

try DateAdd( hh, -6, HX_ENTRIES.EVENTTIME )

--
HTH,
David Satz
Principal Web Engineer
Hyperion Solutions

"Dorothy" <dottie.adams@conserveschool.org> wrote in message
news:3dfa427a$1@tnews.web.dev-archive.com...
>
> Hello,
>
> I currently have a timestamp in a table that records in Greenwich Mean
Time.
> When running my query I need the time converted to CST (I need to
subtract
> 6 hours). Any thoughts on how I can accomplish this? Should I just
subtract
> 6 from the Eventtime (the column that stores this data). How would I
script
> this? Any suggestions would be appreciated! I'll post my query below.
>
> Thanks,
> Dorothy Adams
> Conserve School Technology Specialist
>
> SELECT Count(HX_EVENTS.EVENTID)
> FROM NT3400.dbo.HX_AUXDATA HX_AUXDATA, NT3400.dbo.HX_ENTRIES HX_ENTRIES,
> NT3400.dbo.HX_EVENTS HX_EVENTS
> WHERE HX_AUXDATA.ENTRYID = HX_ENTRIES.ENTRYID AND HX_AUXDATA.ENTRYID =
HX_EVENTS.ENTRYID
> AND HX_AUXDATA.OBJSITE = HX_ENTRIES.OBJSITE AND HX_AUXDATA.OBJSITE =
HX_EVENTS.OBJSITE
> AND HX_ENTRIES.ENTRYID = HX_EVENTS.ENTRYID AND HX_ENTRIES.OBJSITE =
HX_EVENTS.OBJSITE
> AND ((HX_ENTRIES.EVENTTIME>=? And HX_ENTRIES.EVENTTIME<=?) AND
(HX_AUXDATA.ITEMDATA='LAB
> Cafe Cashier #1') AND (Datepart(Hour,HX_ENTRIES.EVENTTIME) Between 20 And
> 23))