TO CHAR(dates)

From SQLZOO
Revision as of 15:02, 16 July 2012 by Connor (Talk | contribs)

Jump to: navigation, search
Compatibility
TO_CHAR(d,'YYYY')
EngineOKAlternative
ingresNoEXTRACT(HOUR from d)
mysqlNoEXTRACT(HOUR from d)
oracleYes
postgresNoEXTRACT(HOUR from d)
sqlserverNoDATEPART(HOUR,d)

TO_CHAR (dates)

TO_CHAR allows you to convert a date to a string using a variety of formats.

 TO_CHAR(d, 'YYYY') -> Four digit year
 TO_CHAR(d, 'MM')   -> Two digit month
 TO_CHAR(d, 'DD')   -> Two digit day
 TO_CHAR(d, 'HH24') -> Two digit hour
 TO_CHAR(d, 'MI')   -> Two digit minutes
 TO_CHAR(d, 'MON')  -> Three character month

In this example you get the month as a three character abbreviation and a four digit year from the date field whn.

SELECT DATEPART(YEAR FROM whn) AS v
      ,whn
      ,wht
  FROM eclipse
SELECT TO_CHAR(whn, 'MON YYYY') AS v
      ,whn
      ,wht
  FROM gisq.eclipse
SELECT EXTRACT(YEAR FROM whn) AS v, whn, wht
  FROM eclipse

See also

Personal tools
Namespaces

Variants
Actions
Reference
Toolbox
Google AdSense