Re: select julian day from datetime field

[Anthony Willard]

You can also use the DATE_FORAMT() function.

SELECT DATE_FORMAT( some_date_var, '%y%j' )
FROM mytable;