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


 

Content with tag CAST Rss

   Items 1 to 4 of 4   
 

Casting question

Read more...
By Eli Leiba 2013/03/15 | Category: convert
Rating: (not yet rated) |  Discuss |   Briefcase | 1,739 reads

Five percent rounded down

Read more...
By Mike Tanner 2012/10/24 | Category: cast
Rating: (not yet rated) |  Discuss |   Briefcase | 2,050 reads

GetDateTimeString Function

This function gets a variable and converts to DateTime format string 'YYYYMMDDHHMM' Ex. '07/11/2009 2:05 PM' Convert to '200907111405'  Read more...
By Luis Atondo 2009/07/31 | Source: SQLServerCentral.com | Category: datetime
Rating: |  Discuss |   Briefcase | 866 reads

GetDateTime Function

This function gets a variable string and converts to DateTime format 'YYYY-MM-DD HH:MM' Ex. '200907111405' Convert to '2009-07-11 14:05:00'   Read more...
By Luis Atondo 2009/07/30 | Source: SQLServerCentral.com | Category: convert
Rating: |  Discuss |   Briefcase | 995 reads
   Items 1 to 4 of 4   
 
Tags
convert (3)    
datetime (2)    
function (2)    
t-sql (2)    
datepart (1)    
len() (1)    
rounding (1)    
substring (1)    
truncation (1)    
 
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved. Privacy Policy. Terms of Use. Report Abuse.