Re: [GENERAL] pgsql age function showing 00:00:00 with year argument

2014-06-23 Thread Albe Laurenz
Arup Rakshit wrote: > yelloday-staging::YELLOW=> select id, dob from users; > id | dob > +- > 13 | > 9 | 1967-02-13 14:00:00 > 10 | > 11 | > 8 | 1977-06-05 14:00:00 > 15 | > 21 | > 14 | 2014-05-25 14:00:00 > 37 | > 22 | > 26 | 2014-05-06 14:00:00 > 32

[GENERAL] pgsql age function showing 00:00:00 with year argument

2014-06-23 Thread Arup Rakshit
Look the below 2 scenarios :- yelloday-staging::YELLOW=> select id, dob from users;  id |         dob          +-  13 |    9 | 1967-02-13 14:00:00  10 |   11 |    8 | 1977-06-05 14:00:00  15 |   21 |   14 | 2014-05-25 14:00:00  37 |   22 |   26 | 2014-05-06 14:00:00  32 |