I have column year datatype varchar which goes in to column date datatype timestamp and i am getting errors how can i convert varchar to timestamp keeping the same format
so
Code: Select all
Source (Varchar) Target(timestamp)
2004 2004
2005 2005