[SQL] DateDiff() function

2013-07-10 Thread Huan Ruan
Hi Guys We are migrating to Postgres. In the current system, we use datediff() function to get the difference between two dates, e.g. datediff (month, cast('2013-01-01' as timestamp), cast('2013-02-02' as timestamp) returns 1. I understand that Postgres has Interval data type so I can achieve the

Re: [SQL] DateDiff() function

2013-07-10 Thread Gavin Flower
On 11/07/13 17:17, Huan Ruan wrote: Hi Guys We are migrating to Postgres. In the current system, we use datediff() function to get the difference between two dates, e.g. datediff (month, cast('2013-01-01' as timestamp), cast('2013-02-02' as timestamp) returns 1. I understand that Postgres h