Erwin, > I read your FAQ: Working with Dates and Times in PostgreSQL with > interest > and was wondering if somebody came up with those datediff and dateadd > functions? > I couldn't find any at techdocs.postgresql.org.
I know somebody worked on one. I take it you read the articles on SQL Server ---> PostgreSQL conversion? The problem, as I recall, was one of quoted identifiers. That is, for datediff, you do: DATEDIFF ( m, date1, date2 ) whereas a postgresql function would have to say DATEDIFF ( 'm', date1, date2 ) I don't know if anyone ever worked out a way around this minor problem. -Josh ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
