Actually I figured this out with help from another forum. The SQL
command I needed apparently is specific to the Informix database I was
connecting to.
select * from calls where timestamp '2007-06-07 19:48:58'
unlike sql server it doesn't take am/pm. It needs 24 hr format. I also
needs - instead of / and year first. That kind of formatting issue is
apparently all it took.
Thanks for the help.
cj wrote:
I have a sql db table with a field of type DATETIME.
I want to do something like this:
select * from calls where timestamp date("6/7/2007 7:00")
problem is date only works with a date with out the time. How can I get
the time in?