SQL Julian Dates
Posted on 2004-09-01
My problem is, unfortunately I am not beardy at all (our term for meaning technically advanced!), so I wonder if I could ask a question and hopefully get an answer that I can just slot right into my criteria? I am pulling data using ODBC drivers from a package that uses KCML language (don't know if this is common or not). When I try to restrict my data by date I get an error message from the source as it does not understand the language, however I have managed to get it to understand julian date format (I don't know how but it works!). The problem is that I need the criteria to say 'pull everything with a date of less than today' therefore I need the julian function for today. I have attached a copy of my statement below, could you take a look and let me know any suggestions?
AND ServiceHistory.DateOfService < 'TODAY'
Smooth Skin (ie no beard)