Difference between revisions of "TO CHAR(dates)"
From SQLZOO
| 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 15:28, 16 July 2012
| TO_CHAR(d,'YYYY') | ||
|---|---|---|
| Engine | OK | Alternative |
| ingres | No | EXTRACT(HOUR from d) |
| mysql | No | EXTRACT(HOUR from d) |
| oracle | Yes | |
| postgres | No | EXTRACT(HOUR from d) |
| sqlserver | No | DATEPART(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
