Jan 6, 2010 #1 admoore IS-IT--Management May 17, 2002 224 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 Jun 30, 2002 8,847 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