Results 1 to 2 of 2

Thread: SQL Statement Need Help URGENT!

  1. #1
    Join Date
    Oct 2002
    Posts
    1

    Exclamation SQL Statement Need Help URGENT!

    i have a table in DB store the value of date format (log_date) as yyyy/mm/dd, now i would like to select the data which log_date month is September. So how is the SQL select statement look like?

  2. #2
    Join Date
    Oct 2002
    Posts
    1
    Try

    SELECT *
    FROM <table>
    WHERE date LIKE '%/09/%'

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •