In my project I have PostgreSql table which contain date (Data type date)column. The date received from column is being passed to getData function.
I am getting output in format 03122021, which I want to convert in format 2021-12-03 (YYYY-MM-DD) DATE ONLY. How can I make the conversion?
async getData(date){
console.log("date is ", date); ---->>> date is 03122021
const d = new Date(Date.parse(date));
console.log('d', d) ---->> d Invalid Date
}
So parse the sting into a format it recognizes
const date = '03122021'
const d = new Date(date.replace(/(\d{2})(\d{2})(\d{4})/,'$2/$1/$3'));
console.log(d);
const d2 = date.replace(/(\d{2})(\d{2})(\d{4})/,'$3-$2-$1');
console.log(d2);You could convert the date in your sql query:
SELECT TO_CHAR(dateColumn, 'yyyy-mm-dd') AS formattedDate FROM ...
I know this is not perfect answer but if you get this type of value alltime , then you can do this
const dateValue = '03122021'
let day = dateValue.substring(0,2)
let month = dateValue.substring(2,4)
let year = dateValue.substring(4,8)
const date =`${year}-${month}-${day}`
console.log(date)