Not exactly sure how your db handles INTERVAL functions, but you could select your <datetime> + <interval> AS offsetDateTime. <interval> being a CF variable equaling your offset, which would be 0 for anything local, 2 for your example.
Adam. > -----Original Message----- > From: Jeff Beer [mailto:[EMAIL PROTECTED]] > Sent: Thursday, March 21, 2002 2:01 PM > To: CF-Talk > Subject: dateadd with grouped query and cfgraph > > > I run a graph on a server in a different time zone. I'd like > to modify the > times (hour only) by adding two hours. However, the query is > grouped by day > and hour, then fed into CFGRAPH. > > Anyone know if this can be done without modifying the data in > the table? > > Thanks! > > Jeff > > ______________________________________________________________________ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists