CODEWITHSUNDEEP
sqloracle-database
hudi
hudi

Reputation: 16525

select date from oracle database

I have this value of date in database: 01-03-12 13:25:50. How I can select this date in this format: DD.MM.YYYY . I try to round it: ROUND(to_date(datum_zalozeni, 'DD-MM-YYYY HH:MI:SS'),'DAY') but format is still same...

Upvotes: 1

Views: 7226

Answers (4)

diederikh
diederikh

Reputation: 25271

to_char(to_date(datum_zalozeni, 'DD-MM-YYYY HH:MI:SS'),'DD.MM.YYYY')

Upvotes: 0

Korhan Ozturk
Korhan Ozturk

Reputation: 11308

Try this: 

select to_char(datum_zalozeni, 'DD-MM-YYYY')

Upvotes: 0

Tony Andrews
Tony Andrews

Reputation: 132570

If it is a DATE then you can do this:

select to_char( mycol, 'DD.MM.YYYY') from mytable;

Upvotes: 0

Roland Bouman
Roland Bouman

Reputation: 31961

Use TO_CHAR(datum_zalozeni, 'DD.MM.YYYY')

Official docs for TO_CHAR: http://docs.oracle.com/cd/B19306_01/server.102/b14200/functions180.htm

Formats for dates: http://docs.oracle.com/cd/B19306_01/server.102/b14200/sql_elements004.htm#sthref416

Upvotes: 1

Related Questions