Re: Sybase to postgres Timestamp column - Mailing list pgsql-admin

From Erik Wienhold
Subject Re: Sybase to postgres Timestamp column
Date
Msg-id fd4170a9-c849-4226-b6d0-35560b6a805b@ewie.name
Whole thread Raw
In response to Sybase to postgres Timestamp column  (SASIKUMAR Devaraj <sashikumard@yahoo.com>)
Responses Re: Sybase to postgres Timestamp column
List pgsql-admin
On 2026-01-21 14:53 +0100, SASIKUMAR Devaraj wrote:
> When we are migrating from sybase to postgres, we are facing issues
> with Timestamp field format and not matching.
> Sybase format: Jan 21 2026 5:35 PM
> Please advise any workaround is there?

I'm not familiar with Sybase.  What issues are you facing?  Please
provide more details such as database schema, error messages or expected
vs. actual results.

But Postgres should accept this timestamp format without issue:

    SELECT 'Jan 21 2026 5:35 PM'::timestamp;
          timestamp
    ---------------------
     2026-01-21 17:35:00
    (1 row)

-- 
Erik Wienhold



pgsql-admin by date:

Previous
From: SASIKUMAR Devaraj
Date:
Subject: Sybase to postgres Timestamp column
Next
From: Tom Lane
Date:
Subject: Re: Sybase to postgres Timestamp column