User Profile

Collapse

Profile Sidebar

Collapse
mbolan77
mbolan77
Last Activity: Oct 2 '06, 08:53 PM
Joined: Sep 28 '06
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts

  • Thanks for your response, I appreciate it.

    Apparently I'm a moron on 2 counts.. :-)
    1. I'm actually using WinSQL to query the database, not MySQL as I incorrectly noted in my previous post (not sure if that makes a diff)
    2. I tried your suggestion and still can't get it to work (perhaps cuz of #1 above???). I get this message:

    Error: Incorrect syntax near the keyword 'CURRENT_DATE'. (State:37000, Native...
    See more | Go to post

    Leave a comment:


  • SQL to automatically select only current date's rows

    Hello...

    I have a table with a number of fields along with a time stamp column... I am wondering how I can query for only rows inserted on the current date other than manually entering the date parameter... An example below:

    Let's say I had a table like this:

    OFF_ID OFFER RESULT ENTRY_TS
    2719 MAGAZINE NOT INTERESTED 2006-09-27 16:11:06.678
    2720 CAR ACCEPT 2006-09-27 16:15:02.231
    ...
    See more | Go to post
No activity results to display
Show More
Working...