CODEWITHSUNDEEP
oracle-databasedelphi
Atanas Penkov
Atanas Penkov

Reputation: 1

how to format a date in delphi

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!

Upvotes: 0

Views: 1239

Answers (2)

Bob Jarvis - Слава Україні
Bob Jarvis - Слава Україні

Reputation: 50017

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.

Upvotes: 0

cagcowboy
cagcowboy

Reputation: 30838

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

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

Upvotes: 3

Related Questions