VistaDB 6
VistaDB / Developer's Guide / SQL Reference / Functions / Date and Time Functions / YEAR
In This Topic
YEAR
In This Topic
YEAR( datetime )

Returns an integer representing the YEAR from a given datetime.


Remarks

This is the same as using DATEPART( year, date )

Example

Output: 2007
Output: 4, 28, 2007
SELECT MONTH('4/28/2007'), DAY('4/28/2007'), YEAR('4/28/2007')
SELECT YEAR('4/28/2007')

See Also