Re: [SQL] Date manipulation

2001-06-01 Thread Josh Berkus
Mark, > How does one perform date manipulation within SQL? For example, SQL > Server has a dateadd() function that takes a date part, scalar, and > the > date to manipulate. As I have remarked before, such functions as DATEADD are unnecessary in PostgreSQL because PostgreSQL has a proper implem

[SQL] Date manipulation

2001-05-31 Thread Mark
How does one perform date manipulation within SQL? For example, SQL Server has a dateadd() function that takes a date part, scalar, and the date to manipulate. I have a query that determines the number of days that are between now and a particular date that looks something like this: select da