how do I convert a date to YYYYMMDD?

jo112358 Published at Dev

jo112358

I have two tables with two different date formats and I need to compare them. I am trying to convert the field Q_RATE_DATE; how do I change it from '27-JUN-12' to 20120627?

I tried:

TO_DATE(Q_RATE_DATE, 'DD-MON-YY', 'YYYYMMDD')

no luck, what am I doing wrong?

mathguy

Actually it seems to me that BOTH columns are of character data type - otherwise it does not make sense to speak of "format." And in that case the correct solution is

to_char(to_date(Q_RATE_DATE, 'dd-mon-yy'), 'yyyymmdd')

(Well - actually the correct solution is to store dates in DATE data type, but it is entirely possible the OP has no control over that.)

Collected from the Internet

Please contact [email protected] to delete if infringement.

edited at2021-04-8

Comments

0 comments

How do I convert a Firestore date/Timestamp to a JS Date()?

How do I convert datetime to date (in Python)?

How do I convert a datetime to date?

AngularJS how to convert string "yyyyMMdd" to date

how do I convert a date to YYYYMMDD?

how do I convert a date to YYYYMMDD?

Failed to listen on localhost:8000 (reason: Cannot assign requested address)

How to import an asset in swift using Bundle.main.path() in a react-native native module

Loopback Error: connect ECONNREFUSED 127.0.0.1:3306 (MAMP)

pump.io port in URL

Spring Boot JPA PostgreSQL Web App - Internal Authentication Error

BigQuery - concatenate ignoring NULL

ngClass error (Can't bind ngClass since it isn't a known property of div) in Angular 11.0.3

Do Idle Snowflake Connections Use Cloud Services Credits?

maven-jaxb2-plugin cannot generate classes due to two declarations cause a collision in ObjectFactory class

Compiler error CS0246 (type or namespace not found) on using Ninject in ASP.NET vNext

Can't pre-populate phone number and message body in SMS link on iPhones when SMS app is not running in the background

Generate random UUIDv4 with Elm

Jquery different data trapped from direct mousedown event and simulation via $(this).trigger('mousedown');

Is it possible to Redo commits removed by GitHub Desktop's Undo on a Mac?

flutter: dropdown item programmatically unselect problem

Change dd-mm-yyyy date format of dataframe date column to yyyy-mm-dd

EXCEL: Find sum of values in one column with criteria from other column

Pandas - check if dataframe has negative value in any column

How to use merge windows unallocated space into Ubuntu using GParted?

Make a B+ Tree concurrent thread safe

ggplotly no applicable method for 'plotly_build' applied to an object of class "NULL" if statements