I want to select the current_timestamp in a specific format 'YYYYMMDDHH24MISS'.
Can you please let me know how I should go about it?
If you are particular about current_timestamp, you can think of :
select cast((current_timestamp(FORMAT 'YYYYMMDD')) as char(8))||cast((current_timestamp(FORMAT 'HHMISS')) as char(6))
I have a question, do we need to cast it to varchar while inserting through ODBC ? Or it is only required for display purpose?
Its only for display purpose. You can insert it like '2014-01-01 00:00:00' just fine .... and this is the default format that is suggested to be used with TD.