BUG #17527: Timestamp bind variable using 0000-00-00, 0000/00/00 - Mailing list pgsql-bugs

From PG Bug reporting form
Subject BUG #17527: Timestamp bind variable using 0000-00-00, 0000/00/00
Date
Msg-id 17527-76912eafe534d095@postgresql.org
Whole thread Raw
List pgsql-bugs
The following bug has been logged on the website:

Bug reference:      17527
Logged by:          Lee Jae Hyun
Email address:      jhlee@warevalley.com
PostgreSQL version: 10.3
Operating system:   Windows 10
Description:

I would like to inform you that it is being used in Korea and has been
translated into Korean -> English through a translator.

Question about variable binding failure for timestamp column in postgresql

The test was conducted on ODBC Drvier 13.00.00.00, and the server is the
same as the 11.7 and 10.3 versions.

1. Sample Data

create table t1 (data timestamp);
insert into t1 ( data ) values ( ? );
-- Bind variable ( 2022-06-22) successful;
-- Bind variable (2022/06/22) failed;

Can bind variables in 0000/00/00 format be used in ODBC? Or, I would like to
ask if it is possible to use only bind variables of 0000-00 unconditionally.


pgsql-bugs by date:

Previous
From: PG Bug reporting form
Date:
Subject: BUG #17526: PG_DUMP is not outputting "CREATE SCHEMA" statements when an extension is assigned to a schema
Next
From: Noah Misch
Date:
Subject: Re: Extension pg_trgm, permissions and pg_dump order