Jan 6, 2010 #1 admoore IS-IT--Management Joined May 17, 2002 Messages 224 Location US If I have a query that returns a date expression, how would I go about returning an expression indicating the first day of that month? TIA, -Allen_M.
If I have a query that returns a date expression, how would I go about returning an expression indicating the first day of that month? TIA, -Allen_M.
Jan 6, 2010 2 #2 r937 Technical User Joined Jun 30, 2002 Messages 8,847 Location CA SELECT mydate - INTERVAL DAY(mydate)-1 DAY FROM ... r937.com | rudy.ca Buy my new book Simply SQL from Amazon Upvote 0 Downvote
SELECT mydate - INTERVAL DAY(mydate)-1 DAY FROM ... r937.com | rudy.ca Buy my new book Simply SQL from Amazon