返回数说广场
0
Oracle 数据库今天为 2024-06-25 日,下列哪种方式可以获得“2024-06-25 00:00:00”(DE)
A、trunc(sysdate,'day')
B、to_char(sysdate,'dd')
C、to_char(sysdate,'day')
D、trunc(sysdate)
E、trunc(sysdate,'dd')
解析:
select trunc(sysdate,'day'),to_char(sysdate,'dd'),to_char(sysdate,'day'),trunc(sysdate),trunc(sysdate,'dd') from dual;
trunc | to_char | to_char | trunc | trunc
---------------------+---------+-----------+---------------------+---------------------
2024-06-23 00:00:00 | 25 | tuesday | 2024-06-25 00:00:00 | 2024-06-25 00:00:00
0
0 224
分享
评论
热门数说



