You can always break it up using substr and instr and then bringing it back together in the format you want.
From: veskojl [mailto:email@example.com]
Sent: Wednesday, June 14, 2017 12:13 AM
Subject: [Toad Data Point - Discussion Forum] Custom DATE format for ODBC (PostgreSQL)
Custom DATE format for ODBC (PostgreSQL)
Thread created by veskojl
I’m using TDP 188.8.131.52 to connect to a PostgreSQL database. The thing is I want the DATE and the DATETIME columns to be formatted in a different way:
Date = yyyy-MM-dd
TimeStamp = yyyy-MM-dd hh:mm:ss
I’ve tried to set up a custom format just for the dates by configuring:
Odbc:DATE=yyyy-MM-dd, (as mentioned in a very old thread here)
but this doesn’t seem to work. I’m pretty sure that technique works in “Toad for SQL Server”, where it is possible to have different formatting, but I’m not sure if TDP allows this for ODBC.
Does anybody know if this is feasible at all?
To reply, please reply-all to this email.
Stop receiving emails on this subject.
Unsubscribe from Toad Data Point Forum notifications altogether.
Toad Data Point - Discussion Forum
this post as spam/abuse.