Re: Re: Date Time Functions - ANSI SQL ?

From: "Josh Berkus" <josh(at)agliodbs(dot)com>
To: Gonzo Rock <GonzoRock(at)Excite(dot)com>
Cc: <pgsql-sql(at)postgresql(dot)org>
Subject: Re: Re: Date Time Functions - ANSI SQL ?
Date: 2001-08-05 22:12:12
Message-ID: web-97094@davinci.ethosmedia.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Gonzo,

> > I'm trying to find a pgSQL source that documents the Non-Standard
> > pgSQL stuff, the stuff that will break when attempting to execute
> > against mySQL/Oracle/MSSQLServer etc...

Almost anything you port will break MS SQL Server (7.0 and 6.5, anyway).
SQL Server is so far off the ANSI standard for Dates & Times that no
application may be ported from another server which relies on dates and
time manipulation.

FYI.

-Josh Berkus

______AGLIO DATABASE SOLUTIONS___________________________
Josh Berkus
Complete information technology josh(at)agliodbs(dot)com
and data management solutions (415) 565-7293
for law firms, small businesses fax 621-2533
and non-profit organizations. San Francisco

Attachment Content-Type Size
unknown_filename text/plain 2 bytes
unknown_filename text/plain 2 bytes
unknown_filename text/plain 2 bytes

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Allan Engelhardt 2001-08-05 22:20:05 Re: Data type confusion
Previous Message Josh Berkus 2001-08-05 22:05:46 Data type confusion