Biznas
»
OS and Software
»
Web Developers
»
How do I convert mm/dd/yyyy hh:mm:ss to mm/dd/yyyy in MySQL and Oracle?
Rank: Newbie
Groups: Registered
Joined: 2/23/2023(UTC) Posts: 2 Location: USA
|
How do I convert mm/dd/yyyy hh:mm:ss to mm/dd/yyyy in MySQL and Oracle?
|
|
|
|
Rank: Member
Groups: Registered
Joined: 11/3/2022(UTC) Posts: 23 Location: USA
|
At first glance, this might appear to be a date conversion question, but because you are converting one format to another, it is really just a string manipulation question.
It looks like you just want the 10 leftmost characters, which you can get using a SUBSTR(<input string>, 1,10) in Oracle PL/SQL.
LEFT(<inputstring>, 10) will do this in MySQL.
|
|
|
|
Rank: Newbie
Groups: Registered
Joined: 3/4/2023(UTC) Posts: 2 Location: USA
|
Recently, I was interested in the question of how to convert only time to date in sql, and I managed to find answers in one article. Where we talked about sql convert date to mm dd yyyy, and described it step by step. You may also find this information useful, they also have many other useful articles on the site on similar topics that may be useful to you in the future.
|
|
|
|
Biznas
»
OS and Software
»
Web Developers
»
How do I convert mm/dd/yyyy hh:mm:ss to mm/dd/yyyy in MySQL and Oracle?
Forum Jump
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.