Browse by Tags

• Time Interval

• Conversion from string to datetime2, time, date is timezone un-awared

  In SQL Server 2008, An instance of DateTimeOffset type can represent: 1) A local time + a time zone offset 2) A UTC time + a time zone offset 3) A local time and a UTC time. When converting such an instance to other date and time types, such as datetime Read More... Posted Monday, August 18, 2008 7:27 PM by Qingsong Yao | 0 Comments Filed under: DateTime

• Colon(:) and dot (.) in factional second is not the same

  Colon and Dot are two symbol to separate the second and factional second in a given time string. If we create following queries: select CAST ( '1999-12-21 01:01:01.12' as datetime ) ----------------------- 1999-12-21 01:01:01.120 select CAST ( '1999-12-21 Read More... Posted Monday, August 04, 2008 10:53 PM by Qingsong Yao | 0 Comments Filed under: DateTime

• Idea about implementing a time internal type in SQL Serve 2008

  In SQL Server 2008, we implement several new date and time types which follow the ISO SQL standard. The one ISO SQL type which is missing in SQL Server 2008 is the time internal type. Today, I will present some idea about implementing a time internal Read More... Posted Friday, August 01, 2008 6:19 PM by Qingsong Yao | 0 Comments Filed under: DateTime, Time Interval