pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedIs DATETIME an ANSI-SQL type?
4+ messages / 3 participants
[nested] [flat]
* Is DATETIME an ANSI-SQL type?
@ 2008-01-15 13:18 Joost Kraaijeveld <J.Kraaijeveld@Askesis.nl>
2008-01-15 13:45 ` Re: Is DATETIME an ANSI-SQL type? Magne Mæhre <Magne.Mahre@Sun.COM>
0 siblings, 1 reply; 4+ messages in thread
From: Joost Kraaijeveld @ 2008-01-15 13:18 UTC (permalink / raw)
To: pgsql-sql
Hi,
Well the subject says it all:
Can anyone tell me if DATETIME is an ANSI SQL type?
TIA
--
Groeten,
Joost Kraaijeveld
Askesis B.V.
Molukkenstraat 14
6524NB Nijmegen
tel: 024-3888063 / 06-51855277
fax: 024-3608416
web: www.askesis.nl
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Is DATETIME an ANSI-SQL type?
2008-01-15 13:18 Is DATETIME an ANSI-SQL type? Joost Kraaijeveld <J.Kraaijeveld@Askesis.nl>
@ 2008-01-15 13:45 ` Magne Mæhre <Magne.Mahre@Sun.COM>
2008-01-15 15:53 ` Re: Is DATETIME an ANSI-SQL type? Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 1 reply; 4+ messages in thread
From: Magne Mæhre @ 2008-01-15 13:45 UTC (permalink / raw)
To: Joost Kraaijeveld <J.Kraaijeveld@Askesis.nl>; +Cc: pgsql-sql
Joost Kraaijeveld wrote:
> Hi,
>
> Well the subject says it all:
>
> Can anyone tell me if DATETIME is an ANSI SQL type?
No.
The Datetime types defined in SQL (ISO/IEC 9075:2003) are
DATE
TIME WITHOUT TIME ZONE
TIME WITH TIME ZONE
TIMESTAMP WITHOUT TIME ZONE
TIMESTAMP WITH TIME ZONE
--Magne
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Is DATETIME an ANSI-SQL type?
2008-01-15 13:18 Is DATETIME an ANSI-SQL type? Joost Kraaijeveld <J.Kraaijeveld@Askesis.nl>
2008-01-15 13:45 ` Re: Is DATETIME an ANSI-SQL type? Magne Mæhre <Magne.Mahre@Sun.COM>
@ 2008-01-15 15:53 ` Tom Lane <tgl@sss.pgh.pa.us>
2008-01-15 19:42 ` Re: Is DATETIME an ANSI-SQL type? Joost Kraaijeveld <J.Kraaijeveld@Askesis.nl>
0 siblings, 1 reply; 4+ messages in thread
From: Tom Lane @ 2008-01-15 15:53 UTC (permalink / raw)
To: Magne Mæhre <Magne.Mahre@Sun.COM>; +Cc: Joost Kraaijeveld <J.Kraaijeveld@Askesis.nl>; pgsql-sql
=?ISO-8859-1?Q?Magne_M=E6hre?= <Magne.Mahre@Sun.COM> writes:
> Joost Kraaijeveld wrote:
>> Can anyone tell me if DATETIME is an ANSI SQL type?
> No.
> The Datetime types defined in SQL (ISO/IEC 9075:2003) are
> DATE
> TIME WITHOUT TIME ZONE
> TIME WITH TIME ZONE
> TIMESTAMP WITHOUT TIME ZONE
> TIMESTAMP WITH TIME ZONE
If you need to port from a system that used DATETIME as a type name,
consider defining DATETIME as a domain over whichever of the standard
types seems to have the closest semantics (likely the last of these).
regards, tom lane
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Is DATETIME an ANSI-SQL type?
2008-01-15 13:18 Is DATETIME an ANSI-SQL type? Joost Kraaijeveld <J.Kraaijeveld@Askesis.nl>
2008-01-15 13:45 ` Re: Is DATETIME an ANSI-SQL type? Magne Mæhre <Magne.Mahre@Sun.COM>
2008-01-15 15:53 ` Re: Is DATETIME an ANSI-SQL type? Tom Lane <tgl@sss.pgh.pa.us>
@ 2008-01-15 19:42 ` Joost Kraaijeveld <J.Kraaijeveld@Askesis.nl>
0 siblings, 0 replies; 4+ messages in thread
From: Joost Kraaijeveld @ 2008-01-15 19:42 UTC (permalink / raw)
To: Tom Lane <tgl@sss.pgh.pa.us>; +Cc: Magne Mæhre <Magne.Mahre@Sun.COM>; pgsql-sql
Hi,
On Tue, 2008-01-15 at 10:53 -0500, Tom Lane wrote:
> =?ISO-8859-1?Q?Magne_M=E6hre?= <Magne.Mahre@Sun.COM> writes:
> > Joost Kraaijeveld wrote:
> >> Can anyone tell me if DATETIME is an ANSI SQL type?
>
> > No.
> > The Datetime types defined in SQL (ISO/IEC 9075:2003) are
>
> > DATE
> > TIME WITHOUT TIME ZONE
> > TIME WITH TIME ZONE
> > TIMESTAMP WITHOUT TIME ZONE
> > TIMESTAMP WITH TIME ZONE
>
> If you need to port from a system that used DATETIME as a type name,
> consider defining DATETIME as a domain over whichever of the standard
> types seems to have the closest semantics (likely the last of these).
Thanks for the confirmation and tips.
--
Groeten,
Joost Kraaijeveld
Askesis B.V.
Molukkenstraat 14
6524NB Nijmegen
tel: 024-3888063 / 06-51855277
fax: 024-3608416
web: www.askesis.nl
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2008-01-15 19:42 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2008-01-15 13:18 Is DATETIME an ANSI-SQL type? Joost Kraaijeveld <J.Kraaijeveld@Askesis.nl>
2008-01-15 13:45 ` Magne Mæhre <Magne.Mahre@Sun.COM>
2008-01-15 15:53 ` Tom Lane <tgl@sss.pgh.pa.us>
2008-01-15 19:42 ` Joost Kraaijeveld <J.Kraaijeveld@Askesis.nl>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox