CODEWITHSUNDEEP
sqloracle-database
neha
neha

Reputation: 3

How can we convert a current date to Julian date /day

How can we format the current date into the Julian date?

And how can we format the current date into HHMMSS format without '.' 'S?

For example:

I should get the format as :123022 not in 12.30.22

Upvotes: 0

Views: 5442

Answers (1)

LMiranda
LMiranda

Reputation: 103

you can format the date with the to_char function and an mask.

For example to display HHMMSS use:

select to_char(sysdate, 'HHMISS') from dual;

To see the Julian time use:

select to_char(sysdate, 'J') from dual;

You can see more information about the mask here: to_char function

Upvotes: 2

Related Questions