Have you looked at the date functions? Like, say, dateAdd()? On Wed, Oct 10, 2012 at 4:34 PM, fun and learning <funandlrnn...@gmail.com>wrote:
> > Hi ALl - > > Here is the scenario I am working on. > > We have certain data that should not be displayed until a certain date and > time. For example, in database we save this date and time and on web page > we check if the data has passed that date and time. All the data is assumed > to be saved in CST since our local time zone is CST > > Now, it is required to assume that the time saved is in EST. So when we > set that the data should not be displayed until 10/11/2012 12PM, the data > should be displayed at 11AM CST on 10/11/2012 instead of 12PM CST. How can > I update my query to subtract one hour? > > query would be like: > > select * from tbl where date < #Now()# > > Thanks. > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:352884 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm