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,601 reads

What will convert return?

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

Casting question

By Eli Leiba 2013/03/15 | Category: convert
Rating: (not yet rated) |  Discuss |   Briefcase | 1,965 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,527 reads

Predict the outcome of the SQL statements

By SQL Buzz 2010/11/02 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 2,841 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,696 reads

Predict the outcome of the SQL statements

By SQL Buzz 2010/09/02 | Category: convert
Rating: (not yet rated) |  Discuss |   Briefcase | 3,266 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,366 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 | 906 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,050 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)