Re: Sybase to postgres Timestamp column

From: Erik Wienhold <ewie(at)ewie(dot)name>
To: SASIKUMAR Devaraj <sashikumard(at)yahoo(dot)com>
Cc: pgsql-admin(at)lists(dot)postgresql(dot)org
Subject: Re: Sybase to postgres Timestamp column
Date: 2026-01-21 14:25:59
Message-ID: fd4170a9-c849-4226-b6d0-35560b6a805b@ewie.name
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2026-01-21 15:06:35 Re: Sybase to postgres Timestamp column
Previous Message SASIKUMAR Devaraj 2026-01-21 13:53:27 Sybase to postgres Timestamp column