I am new to SQL and am having some difficulty manipulating date/time fields using sql. I have two columns: One is date/time formatted (2010-02-16 06:56:00.000) and the other is a text ID. I would like to make a new primary key field (text field) that is a combination of the ID & the date. Ideally I would like this in the following format: ID_dd/mm/yyyy hh:mm:ss (24hr).
I don't seem to see an style option for this time of date-time conversion. Does anyone know of a way to get this data into that format? Not sure if it's possible.