Browse by Tags

Tagged Content List
  • Blog Post: 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 type, we will use the local time and...
  • Blog Post: 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 01:01:01:12' as datetime ) ...
  • Blog Post: 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 types in SQL Server 2008. A time interval is the...
Page 1 of 1 (3 items)