heliosk
Reputation: 1159
Convert date(varchar) and time(varchar) to datetime Oracle
How can I convert two varchar fields in Oracle to a datetime type? I have one field for date ('2014-07-19') and a field for time ('08:00'), I need this to be like '2014-07-19 08:00' in datetime Oracle.
Upvotes: 0
Views: 8481
Answers (1)
Wernfried Domscheit
Reputation: 59602
Do this:
TO_DATE(DATE_COLUMN||TIME_COLUMN, 'yyyy-mm-ddHH24:mi')
Upvotes: 1
Related Questions
- Convert datetime field to just a date field in SQL (Oracle)
- Convert date/time in oracle table
- Convert to datetime to specified format
- Convert date in string format to datetime format in oracle sql
- Convert varchar into datetime in oracle
- Trying to convert datetime in date in oracle
- How to convert date to datetime in Oracle?
- How to convert date(string type) into date(date time ) in oracle
- How to transform Oracle DateTime to Date
- Convert to DateTime in Oracle