postgres sql get Date from timestamp.
To get day part from Timestamp.
SELECT date_trunc('day', TIMESTAMP '2001-02-16 20:38:40');
More details of date_trunc functions.
Subscribe To
Posts
Comments
Posts
Comments
No comments:
Post a Comment