Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 3 of 3
  1. #1
    Registered User
    Join Date
    Jun 2002
    Location
    Arizona
    Posts
    175
    Thanks
    0
    Thanked 0 Times in 0 Posts

    selecting fields with the same month

    how can i select all the fields in a table with say the month june?

    i have a column that is datetime

  • #2
    Super Moderator
    Join Date
    May 2002
    Location
    Perth Australia
    Posts
    4,040
    Thanks
    10
    Thanked 92 Times in 90 Posts
    use could use substring (though there may be a better way) - you just need to know what the date fornat is... i.e. with a TIMESTAMP(14)

    SELECT * FROM $table WHERE SUBSTRING(fieldname,5,2)='06'
    resistance is...

    MVC is the current buzz in web application architectures. It comes from event-driven desktop application design and doesn't fit into web application design very well. But luckily nobody really knows what MVC means, so we can call our presentation layer separation mechanism MVC and move on. (Rasmus Lerdorf)

  • #3
    New to the CF scene
    Join Date
    Jul 2002
    Location
    belgrade, serbia
    Posts
    4
    Thanks
    0
    Thanked 0 Times in 0 Posts

    select month

    you can easily find the desird month:
    SELECT * FROM $table WHERE date_filed LIKE '%-06-%'


  •  

    Posting Permissions

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