This probably might be an easy thing to do, however I'm still not that much of an expert at this, so I would like to ask your help. I have a field of type date in one column of a table and I want to select that field, but the format must be, 14 characters - YYYYMMDDHHMMSS (e.g. 20090215142931)
I have tried: select field (format 'YYYYMMDDHHMMSS') (CHAR(14))
select field (format 'YYYYMMDDHHMISS') (CHAR(14))
But did not get the data successfully. Should I be using cast? or Is the format I'm using wrong?