Re: date format - Mailing list pgsql-general

From Adrian Klaver
Subject Re: date format
Date
Msg-id 3e806c01-a445-79a9-62b7-80a29a1b99eb@aklaver.com
Whole thread Raw
In response to Re: date format  (Marc Millas <marc.millas@mokadb.com>)
List pgsql-general
On 6/14/23 11:23, Marc Millas wrote:
> 
> 


Sort of like?:

https://pgloader.readthedocs.io/en/latest/ref/csv.html

date format

column-name [date format 'YYYY-MM-DD HH24-MI-SS.US']

> 
> 
>     In Postgresql, could you write a simple anonymous procedure that
>     reads the file_fdw table records, does the conversion and then
>     inserts into the destination table?
>     -> one sql line insert as select  using the to_date() function with
>     appropriate format.
> 
>     -- 
>     Born in Arizona, moved to Babylonia.
> 

-- 
Adrian Klaver
adrian.klaver@aklaver.com




pgsql-general by date:

Previous
From: Marc Millas
Date:
Subject: Re: date format
Next
From: Laurenz Albe
Date:
Subject: Re: date format