Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tag Dates and conversion Rss

   Items 1 to 3 of 3   
 

Converting and Using Text Dates as SQL Server Dates

This tip describes some T-SQL techniques for converting a mmddyyyy string to a SQL Server date, handling rows with missing date strings, and comparing converted date strings.  Read more...
By Additional Articles 2015/05/28 | Source: MSSQLTips.com | Category: dates and conversion
Rating: (not yet rated)  Rate this |   Briefcase | 6,918 reads

On Handling Dates in SQL

The handling of dates in TSQL is complex - when SQL Server was Sybase, it was forced by the lack of prevailing standards in SQL to create its own ways of processing and formatting dates and times. Joe Celko looks forward to a future when it is possible to write standard SQL date-processing code with SQL Server.  Read more...
By Additional Articles 2014/03/21 | Source: SimpleTalk | Category: dates and conversion
Rating:  Rate this |   Briefcase | 6,706 reads

Data types in tables

By malls reddy 2013/06/11 | Category: dates and conversion
Rating: (not yet rated) |  Discuss |   Briefcase | 2,146 reads
   Items 1 to 3 of 3   
 
Tags
t-sql (1)