[Resolved] using int field while updating a date field

[kemu_]

I have a int field in my table that has a year info. I would need to update another field that is date field with first day of that year. Any idea how i can combine them in one sql-statement. Im using postgresql.

atm i have something like:
update table set datefield = yearfield + '-01-01' where ...

[jayant]

see http://www.postgresql.org/docs/current/static/functions-datetime.html