I did an intersection between two tables and the resulting field has an sdate of type character varying (29). An example value is 2012-01-13 05:00:00. How do I get just the year from it?
I want to use a postgres query. I tried extract('year' from sdate) but it didn't work because it's type char varying.
أكثر...
I want to use a postgres query. I tried extract('year' from sdate) but it didn't work because it's type char varying.
أكثر...