Need help with query

• dustinprevatt

  Old Hand

  Points: 383

  More actions

  June 20, 2012 at 7:57 am

  #262606

  Here is the query I am working with.

  select *

  from table where cast (postdate AS int(128)) between ({fn Curdate()}) and ({fn Curdate()}) + ({fn minute(1439)})

  I originally had this

  select *

  from dispensedetail where postdate between ({fn Curdate()}) and ({fn Curdate()}) + ({fn minute(1439)})

  But recieved this error - "Conversion failed when converting the varchar value '2012-06-20' to data type int."

  Basically I want to run the query where postdate shown is any time within the start of the current date and the end of the current day.

  Any suggestions??:doze:

• spaghettidba

  SSC Guru

  Points: 105732

  More actions

  June 20, 2012 at 8:28 am

  #1503475

  Duplicate post.

  Replies here please.

  -- Gianluca Sartori