I am looking to convert a date (stored as varchar2) e.g: 4/19/2016 6:42
to this date format MM/DD/YYYY HH24:MI:SS
.
Source field data type - varchar2
target field data type - date
source value - 4/19/2016 6:42
expected value - 04/19/2016 06:42:00
Can someone help with the Oracle (SQL) command for this? SQL code would be preferred over PL/SQL, but anything works.
See Question&Answers more detail:
os 与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…