DATEPART Function
Returns the date as year, month, and day.
| Category: |
Date and Time |
| Returned data type: |
DATE |
Example
The following statement
illustrates the DATEPART function:
|
|
|
select datepart(timestamp '2013-09-24 14:46:58'); |
|
select put(datepart(d), date9.) from myoracle.test; |
|
select put(datepart(t), time12.) from myoracle.test; |
|