我想将时间设置为00:00:00在stock_date中,而不会更改年度,月或日期,即如果日期表示为 07-07-1994 10:45:23
,我想更改它当07-07-1994 00:00:00
时,我环顾四周,但没有发现任何可能有帮助的东西。以下是我的查询。谢谢。
SELECT stock_date AS longDate,
'Tagged containers' AS transactionType,
tagged_cnt AS quantity
FROM RFID_INVENTORY_DAILY_STOCK
WHERE grp_org_id = (SELECT GRP_ORG_ID
FROM GROUP_ORG_MAPPING
WHERE
grp_id =#group_id#
AND org_type = 'S' AND isactive=1
LIMIT 1)
AND stock_date >= #fromDate#
AND stock_date <= #toDate#
使用 date_trunc
这样:
SELECT date_trunc('day', current_timestamp);
date_trunc
------------------------
2017-10-06 00:00:00+02
(1 row)