Greg Luce wrote: > I'm just familiar with Oracle, SQLServer, and Access. Oracle has > "sysdate", while I believe SQL and Access use getdate().
You are right. If we are going to do it according to the standards, better do everything according to the standards :) SELECT current_timestamp AT TIME ZONE '#your_time_zone#' AS myTime Jochem ______________________________________________________________________ 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