completeamateur Posted June 19, 2008 Share Posted June 19, 2008 Hello, I'm trying to query a database to obtain the correct results for a particular season. I'm trying to do this... (YEAR(datetime) = 2008 AND MONTH(datetime) < 07) OR (YEAR(datetime) = 2007 AND MONTH(datetime) >= 07) but it returns no rows. Confused as using one or the other works so I don't see why I can't use both. Thanks in advance. Quote Link to comment Share on other sites More sharing options...
completeamateur Posted June 19, 2008 Author Share Posted June 19, 2008 Ok scrap that, it seems to be working now. Bizarre. Instead, Does anybody know an easy way of converting a single digit to a double, i.e. 1 --> 01 Thanks Quote Link to comment Share on other sites More sharing options...
fenway Posted June 19, 2008 Share Posted June 19, 2008 There's a PERIOD function. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.