MySQL and PgSQL time related operations

mysql Time operation

Get the current time

select now();

2022-01-15 15:31:34.0

Before getting the current time 1 Days time

select DATE_SUB(CURRENT_TIMESTAMP,INTERVAL 1 day);

The optional values are as follows ：

String rotation date

select str_to_date(DATE_SUB(now(),INTERVAL 0 day),'%Y-%m-%d %H:%i:%s');

Time format

select date_format(now(),'%Y-%m-%d %H:%i:%s');

pgsql Time operation

Get the current time

select now();

2022-01-15 15:44:19.619571

Before getting the current time 1 Days time

select now() - interval '1 day'

The optional values are as follows ：

Time format

select to_timestamp(now(),'yyyy-mm-dd hh24:mi:ss') - interval '1 day'

String to time

to_timestamp('2022-01-22 00:00:00','yyyy-MM-dd hh24:mi:ss')

Gets the minutes and seconds of the year, month and day

select extract(year from now()) || extract(month from now()),extract(day from now()),extract(hour from now()),extract(minute from now()),extract(second from now())

String interception

select substr(to_timestamp(now(),'yyyy-mm-dd hh24:mi:ss'),1,19)