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

Content with tag Convert Rss

   Items 1 to 10 of 10   
 

Datetime Formats

This stored procedure will show all possible datetime formats when used with the style argument in the CONVERT() function. It also shows sample output from the date part arguments.  Read more...
By Doug Deneau 2014/10/28 | Source: SQLServerCentral.com | Category: datetime
Rating: |  Discuss |   Briefcase | 1,457 reads

What will convert return?

By RUPESH PATEL 2013/07/11 | Category: convert
Rating: (not yet rated) |  Discuss |   Briefcase | 3,255 reads

Casting question

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

Converting to datetime a char field with several possible date formats

Converting to datetime a char field having several possible date formats  Read more...
By Federico Iori 2013/02/21 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 1,505 reads

Predict the outcome of the SQL statements

By SQL Buzz 2010/11/02 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 2,839 reads

Function to decode HTML string to ASCII

This function decode HTML string to ASCII format string.  Read more...
By andre.brunaldi 2010/10/01 | Source: SQLServerCentral.com | Category: function
Rating: |  Discuss |   Briefcase | 1,681 reads

Predict the outcome of the SQL statements

By SQL Buzz 2010/09/02 | Category: convert
Rating: (not yet rated) |  Discuss |   Briefcase | 3,262 reads

Convert seconds to a timestring

This script converts a number of seconds (integer) to a time string, format 'hh:mm:ss'  Read more...
By Wilfred van Dijk 2010/05/05 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 1,356 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 | 904 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 | 1,047 reads
   Items 1 to 10 of 10   
 
Tags
t-sql (6)    
datetime (4)    
cast (3)    
function (3)    
datepart (2)    
ascii (1)    
case (1)    
date (1)    
date manipulation (1)    
datename (1)    
decode (1)    
html (1)    
len() (1)    
style (1)    
substring (1)    
time (1)