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

What will convert return?

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

Casting question

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

Predict the outcome of the SQL statements

By SQL Buzz 2010/11/02 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 2,838 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,678 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,355 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 | 902 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,031 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)