1. datetime - SQL Server - Convert date field to UTC - Stack ...

    stackoverflow.com/questions/2700197

    I have recently updated my system to record date/times as UTC as previously they were storing as local time. I now need to convert all the local stored date/times to UTC.

  2. TSQL: How to convert local time to UTC? (SQL Server 2008 ...

    stackoverflow.com/questions/1205142

    2/7/2015 · @RobFarley Detecting the time zone at the client and using SWITCHOFFSET can still get things wrong. You need to know whether or not the date and time you ...

  3. sql server - How can I get the correct offset between UTC ...

    https://dba.stackexchange.com/questions/28187/how-can-i-get-the...

    The best way to convert a non-current UTC date into local time is to use the CLR. The code itself is easy; the difficult part is usually convincing people that the ...

  4. TO_DATE - Convert String to Datetime - Oracle to SQL ...

    www.sqlines.com/oracle-to-sql-server/to_date

    Oracle: SQL Server: Syntax: TO_DATE(string, format) CONVERT(DATETIME, string, style) TRY_CONVERT(DATETIME, string, style) Default Format: Specified by NLS_DATE

  5. SQL Server DATE/TIME Workbench - Simple Talk

    https://www.simple-talk.com/sql/learn-sql-server/robyn-pages-sql...

    revised: 21th Aug 2013 by Phil Factor; revised: 20th Sep 2012 by Phil Factor; revised: 11th May 2010 by Phil Factor; Using dates, and times in SQL Server: a workbench ...

  6. SQL Server Central. Microsoft SQL Server tutorials ...

    www.sqlservercentral.com

    The #1 SQL Server community and education site, with articles, news, forums, scripts and FAQs.

  7. SQL Convert function - Kodyaz Development Resources

    www.kodyaz.com/articles/sql-format-date-format-datetime-t-sql...

    How to - SQL Format Date and Format Datetime using T-SQL Convert Function. SQL developers and SQL Server database administrators frequently convert datetime to …

  8. SQL Server Helper - Date and Time Functions

    www.sql-server-helper.com/functions/date-and-time-functions/index.aspx

    SQL Server Date and Time Functions. SQL Server date and time functions are scalar functions that perform an operation on a date and time input value and returns ...

  9. sql - Oracle 9: Convert date from mm/dd/yyyy hh:mm:ss ...

    https://dba.stackexchange.com/questions/107403/oracle-9-convert...

    Note: I only have read access to this database. I need to convert an Oracle 9 date type from d/mm/yyyy hh:mm:ss format to the iso8601 standard. Like the example below ...

  10. Brent Ozar Unlimited - SQL Server Consulting and Training

    https://www.brentozar.com

    Brent Ozar Unlimited's specialized experts focus on your goals, diagnose your tough database pains, and make Microsoft SQL Server faster and more reliable.