How to merge 3 fields into 1 field as a Date?
482108Jan 11 2006 — edited Jan 12 2006Hello All,
The company I work for has an old table data file (SQL table) with 3 seperate field/columns which are 'Day', 'Month', and 'Year' in Alphanumeric type.
Now we want to convert these 3 fields into 1 date field, could anybody help and tell me how to merge them? Thanks in advance!
I just know Excel has the concatenate function to merge things, but because our file is too large, can't use Excel, and have to use SQL table.
Then I have no idea how to use SQL commands to merge fields.
What I want is:
Day Month Year ---> Date
15 04 2002 ----> 15/04/2002
Thank you very much!
Henry