This content has been marked as final. Show 2 replies
Probably this question will be better answered in a postgres database forum.
Normally SQLDeveloper always provides day month and year for every date field, and you can optionally have time.
If you are doing some sort of date conversion manually in your query then obviously you will have to sort out all the details yourself.