Name
datestring , datestring_gmt — convert a datetime from internal to external date-time representation
Synopsis
datestring(
|
in date datetime); |
datestring_gmt(
|
in date datetime); |
Description
datestring and datestring_gmt convert
timestamps or datetimes from internal to
external date-time representation. The external representation is
a human-readable ASCII string of up to 30 characters.
The external format is:
YYYY-MM-DD hh:mm:ss uuuuuu
where
uuuuuu
represents microseconds.
![[Note]](images/note.png)
|
Note: |
|---|---|
|
Using |
Parameters
date
A datetime value.
Return values
datestring and
datestring_GMT return a varchar
.
Examples
Example 24.74. Simple Example
Get current date in human-readable form.
SQL> select datestring(now()); callret VARCHAR _______________________________________________________________________________ 2001-03-01 12:49:59.000000 1 Rows. -- 585 msec.
Example 24.75. A table query example
Get orders shipped later than July 3, 1996
SQL> select left (datestring(ShippedDate), 10) from Orders
where ShippedDate > stringdate ('1996.6.3');
callret
VARCHAR
_______________________________________________________________________________
1996-06-04
1996-06-04
1996-06-05
1996-06-05
1996-06-05
5 Rows. -- 3 msec.
See Also
The discussion of TIMESTAMP datatype in section Database Concepts of the documentation.