Postgres Pro
Downloads
Home   >   mailing lists

Re: Re: Date Time Functions - ANSI SQL ? - Mailing list pgsql-sql

From Josh Berkus
Subject Re: Re: Date Time Functions - ANSI SQL ?
Date
Msg-id web-97094@davinci.ethosmedia.com
Whole thread Raw
In response to Re: Date Time Functions - ANSI SQL ?  (Peter Eisentraut <peter_e@gmx.net>)
List pgsql-sql
Tree view 
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@agliodbs.com
   and data management solutions       (415) 565-7293
  for law firms, small businesses        fax 621-2533
    and non-profit organizations.      San Francisco
Attachment

pgsql-sql by date:

Previous
From: "Josh Berkus"
Date:
Subject: Data type confusion
Next
From: Allan Engelhardt
Date:
Subject: Re: Data type confusion