ORACLE TO_DATE Question

The date on the ORACLE DB is in the form of 202201241201 (YYYYMMDDHHMI) in CHAR format. I'd like to convert this to date format using TO_DATE function in Python's query statement Is there a way to convert the entire column and get it instead of just one specific column?

oracle

2022-09-20 11:18

1 Answers

According to document :

SELECT TO_DATE(column1, 'YYYYMMDDHHMI') as column1date
FROM table1;

2022-09-20 11:18

If you have any answers or tips

Popular Tags

python x 4647

android x 1593

java x 1494

javascript x 1427

c x 927

c++ x 878

ruby-on-rails x 696

php x 692

python3 x 685

html x 656