SoftTree Technologies Technical Support Forums Register • Search • FAQ • Memberlist • Usergroups • Log in SQL Custom Assistance - Date/Time Functions      SoftTree Technologies Forum Index » Tips & Snippets Repository View previous topic View next topic SQL Custom Assistance - Date/Time Functions Author Message judahr Joined: 09 Mar 2007 Posts: 319 Country: United States SQL Custom Assistance - Date/Time Functions ToDateTimeOffset(date DateTime, time_zone varchar(6))DATETIME;Returns a datetimeoffset value that is translated from a datetime2 expression. SwitchOffset(datetimeoffset datetime, time_zone varchar(6))DATETIME;Returns a datetimeoffset value that is changed from the stored time zone offset to a specified new time zone offset. sysdatetimeoffset()DATETIME;Returns a datetimeoffset(7) value that contains the date and time of the computer on which the instance of SQL Server is running. The time zone offset is included. Fri Sep 27, 2013 11:22 am SysOp Site Admin Joined: 26 Nov 2006 Posts: 7930 I have requested to add them to the default SQL Assistant options in version 7. Fri May 23, 2014 12:31 pm Display posts from previous:  All Posts1 Day7 Days2 Weeks1 Month3 Months6 Months1 Year  Oldest FirstNewest First     SoftTree Technologies Forum Index » Tips & Snippets Repository All times are GMT - 4 Hours Page 1 of 1   Jump to:  Select a forum ----------------SQL AssistantDB Audit, DB Mail, DB Tools24x7 Scheduler, Event Server, Automation SuiteTips & Snippets Repository You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum     Powered by phpBB © 2001, 2005 phpBB Group Design by Freestyle XL / Flowers Online.