Julian Day

Database
Ly
Fan

Julian Day

For a SQL statement, how can I get just the julian day (DDD) from a date?:


Accepted Solutions
Ly
Fan

Re: Julian Day

Thank you so much. This worked. 

My apologies for not responding sooner but I was out of town.

i greatly appreciate your time.

1 ACCEPTED SOLUTION
2 REPLIES
Teradata Employee

Re: Julian Day

to_char(Date,'yyddd')
---------------------
17181

or simply:

to_char(Date,'ddd')
-------------------
181

Ly
Fan

Re: Julian Day

Thank you so much. This worked. 

My apologies for not responding sooner but I was out of town.

i greatly appreciate your time.