Comments by haipt232 (Top 1 by date)

thank for your answer :D and i can convert successfully .
if i try 'EUR' that will give DD.MM.YYYY but you can support me how can i replace .(dot) to /(slash)
My code:
select CHAR(DATE(TO_DATE(Day || Month || Year ,'DDMMYYYY')),USA) as Datetime from table.
Because I have 3 fields (field 1:Day, field2: Month , Filed3: Year).And I grouped them 1 field like select command above.
Thanks