This is an easy one "Getdate"

• nszczepanski

  SSC Enthusiast

  Points: 184

  More actions

  October 15, 2004 at 3:27 pm

  #63456

  Hello All,

  I need to compare system date to a date out of a table.  How can I compare the system date to the date_closed as shown below? Should I try to populate a variable using getdate?

  select * from jcjobm where job_stat <> 'A' and date_closed > THIS IS WHERE I NEED HELP "Today's date or getdate?" 

  Thanks,

  -NS

• Carl Farmer

  SSCrazy

  Points: 2197

  More actions

  October 17, 2004 at 2:40 pm

  #526994

  This will do the trick:

  select * from jcjobm where job_stat <> 'A' and date_closed > GETDATE()

   

• Steve Jones - SSC Editor

  SSC Guru

  Points: 736162

  More actions

  October 18, 2004 at 7:27 am

  #527024

  getdate() will get you the exact minute. If you need everything from today, you'd need to calculate the current day minus the time,

  select datepart(mm,getdate() + '/' + datepart(d, getdate())...