开发者

postgres view showing todays orders

开发者 https://www.devze.com 2023-03-28 07:14 出处:网络
Is there a variable built into postgres to represent \"today\"? I want create a view of a table that only shows data that was entered \"today\" there is a datetime field that represents t开发者_如何学

Is there a variable built into postgres to represent "today"? I want create a view of a table that only shows data that was entered "today" there is a datetime field that represents t开发者_如何学编程he date / time an order was entered.


select * from table where date("created_date") = current_date();


There is CURRENT_DATE

SELECT CURRENT_DATE;

See Date/Time Functions

0

精彩评论

暂无评论...
验证码 换一张
取 消