Get the App
SLTechnology News&Howtos  ›  Database  › 

[foam original] Oracle removes Date without using to_char every minute, and then to_date is so troublesome.

Shulou Source: shulou.com Published: 2022-06-01 18:32:07 11月12日 Update

1. Do you encounter the Datetime type in Sql writing and just want to keep it until the date is removed?

2. Do you need to transfer date to varchar and then back to date?

Now, tell all the relatives: don't bother so much!

Select trunc (sysdate) from dual-2013-01-06

Directly OK, from then on light pack, take you to pretend to take you to fly.

Tags: No time trouble tedious light date type light Apple Docker Huawei Linux macOS MariaDB Microsoft MySQL NVidia OPPO Reno Redmi Xiaomi OPPO Reno Shulou Information Apple