Oct 10, 2018 #1 kernal Technical User Joined Feb 27, 2001 Messages 415 Location US How do I convert a datetime 01/16/2018 10:30:08PM TO 2018-01-16 22:30:08? Help is very appreciated!
Oct 11, 2018 2 #2 Beilstwh Programmer Joined Jul 13, 2005 Messages 819 Location US TO_CHAR(MY_DATE_COLUMN,'YYYY-MM-DD HH24:MI:SS') If you are talking about converting a string then TO_CHAR(to_date('01/16/2018 10:30:08PM','MM/DD/YYYY HH:MI:SSPM'),'YYYY-MM-DD HH24:MI:SS') Bill Lead Application Developer New York State, USA Upvote 0 Downvote
TO_CHAR(MY_DATE_COLUMN,'YYYY-MM-DD HH24:MI:SS') If you are talking about converting a string then TO_CHAR(to_date('01/16/2018 10:30:08PM','MM/DD/YYYY HH:MI:SSPM'),'YYYY-MM-DD HH24:MI:SS') Bill Lead Application Developer New York State, USA