Adam, Dave, and anyone who answers before this hits the list - thanks for the assist!!
-----Original Message----- From: Cantrell, Adam [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 21, 2002 3:13 PM To: CF-Talk Subject: RE: dateadd with grouped query and cfgraph 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 > > ______________________________________________________________________ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
