Hi Team,
   I am trying to cast the current timestamp to a formatted string.
{sql}
   CAST(Current_TIMESTAMP AS VARCHAR(14) FORMAT "YYYYMMDDHHmmss")
{sql}
   Not having much luck.  I have tried several permutations but no luck att.
   
   Appreciate being educated on how to do this properly.

Regards & TIA,
Ian

Ian

Try

CAST(CURRENT_TIMESTAMP AS VARCHAR(14) DATE FORMAT 'YYYYMMDD' TIME FORMAT 'HHmmss')

It looks like there's a space between the date & time portions so you may want to do this

REPLACE(' ','',CAST(CURRENT_TIMESTAMP AS VARCHAR(14) DATE FORMAT 'YYYYMMDD' TIME FORMAT 'HHmmss'))

Roy Lambert

Ah Ha!  Tks Roy.