[BUGS] getting only date

Hi all, is there any way to get only date in -MM-DD format from a Timestamp column in potsgresql 6.5 Thanks and regards, praveen _ There is always a better job for you at Monsterindia.com. Go now http://monsterindia.rediff.com/jobs -

[BUGS] problem with query in postgres 6.5

Hi, I was able to run the below query successfully on PostgreSQL 7.0. SELECT substring(now() from 1 for 10); How ever if I run the same query on PostgreSQL 6.5, I am getting the below error. No such function 'substr' with the specified attributes. Can you pls let me know if there is any sol