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

Content with tag dates Rss

   Items 1 to 2 of 2   
 

How to Get SQL Server Dates and Times Horribly Wrong

One of the times that you need things to go right is when you are doing analysis and reporting. This is generally based on time and date. A sure-fire way of getting managers upset is to get the figures horribly wrong by messing up the way that you handle datetime values in SQL Server. In the interests of peace, harmony and a long career in BI, Robert Sheldon outlines some of the worst mistakes you can make when using SQL Server dates.  Read more...
By Additional Articles 2015/06/08 | Source: SimpleTalk | Category: dates
Rating:  Rate this |   Briefcase | 5,991 reads

Convert Months,Days,ShortMonths to different Languages

Convert Months,Days,ShortMonths to Different Langauges with out sql server set language function can be used in views tables and stored procedures also includes proper case conversion  Read more...
By William McLaughlin 2014/02/03 | Source: SQLServerCentral.com | Category: dates
Rating: (not yet rated) |  Discuss |   Briefcase | 934 reads
   Items 1 to 2 of 2   
 
Tags
date conversion (1)    
date manipulation (1)    
datetime (1)    
language conversion (1)    
months (1)    
tips & tricks (1)