postgresql 时间sql

lean789

于 2021-10-20 21:23:57 发布

阅读量221

点赞数

文章标签： sql

本文链接：https://blog.youkuaiyun.com/weixin_45263494/article/details/120875456

版权

这篇博客主要展示了如何使用SQL进行数据统计，包括昨日数据总和（yesterdaySum）与当前数据总和（currentMiles）的查询。通过指定项目ID和时间戳，查询结果分别返回了0和11的值，揭示了数据在不同时间点的变化情况。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

==> Preparing:

select COALESCE(sum(check_length), 0) yesterdaySum from ps_pipe_check where del_flag = 0 and project_id in ( ? , ? ) and to_char(create_time, 'yyyy-MM-dd') = to_char(to_timestamp(?), 'yyyy-MM-dd')
==> Parameters: 1450721552703832066(String), 1450736284907290625(String), 1634649674858(Long)
<== Columns: yesterdaysum
<== Row: 0
<== Total: 1

==> Preparing: select COALESCE(sum(check_length), 0) currentMiles from ps_pipe_check where del_flag = 0 and project_id in ( ? , ? ) and to_char(create_time, 'yyyy-MM-dd') = to_char(to_timestamp(?), 'yyyy-MM-dd')
==> Parameters: 1450721552703832066(String), 1450736284907290625(String), 1634736074(Long)
<== Columns: currentmiles
<== Row: 11
<== Total: 1