Su, Xiaomeng 76a5b1ee83 dli_sqlreference_20240227

Reviewed-by: Pruthi, Vineet <vineet.pruthi@t-systems.com>
Co-authored-by: Su, Xiaomeng <suxiaomeng1@huawei.com>
Co-committed-by: Su, Xiaomeng <suxiaomeng1@huawei.com>

2024-03-27 22:02:33 +00:00

2.3 KiB

Raw Permalink Blame History

getdate

This function is used to return the current system time, in the yyyy-mm-dd hh:mi:ss format.

Similar function: current_date. The current_date function is used to return the current date, in the yyyy-mm-dd format.

Syntax

getdate()

Parameters

None

Return Values

The return value is of the STRING type, in the yyyy-mm-dd hh:mi:ss format.

Example Code

If the current time is 2023-08-10 10:54:00, 2023-08-10 10:54:00 is returned.

select getdate();

Parent topic: Date Functions

2.3 KiB Raw Permalink Blame History