how to format a date in delphi

Question

How should I write the following select in delphi:

select to_char(sysdate, 'dd.mm.yyyy hh:mm:ss) from dual

When I try to execute it I receive an error, but this works:

select to_char(sysdate) from dual

Thanks in advance!

Answer 1

Missing single quote possibly at the end of your format string?

                                            *
select to_char(sysdate, 'dd.mm.yyyy hh:mm:ss') from dual 
                                            *

Answer 2

You might try going in to SQL*Plus and running the query that works so you can see what format Delphi seems to want.

Share and enjoy.