Difference between revisions of "TO CHAR(dates)"

From SQLZOO
Jump to: navigation, search
 
Line 44: Line 44:
 
<ul>
 
<ul>
 
   <li>[[EXTRACT |EXTRACT function]]</li>
 
   <li>[[EXTRACT |EXTRACT function]]</li>
   <li>[[ +(date) function]]</li>
+
   <li>[[%2B(dates) |+(date) function]]</li>
 
   <li>[[HOUR |HOUR function]]</li>
 
   <li>[[HOUR |HOUR function]]</li>
 
   <li>[[MINUTE |MINUTE function]]</li>
 
   <li>[[MINUTE |MINUTE function]]</li>

Latest revision as of 16:28, 16 July 2012

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