Hi!
I've posted this question a couple of times in one form or another, so I'd
really appreciate an answer this time.
I've got a date time field in A SQL DB and it contains both date and times.
I'd like to search it purely by the date value, irrelevent of time. e.g:
SELECT *
FROM myTable
WHERE
I've got a date time field in A SQL DB and it contains both date
and times.
I'd like to search it purely by the date value, irrelevent of time. e.g:
SELECT *
FROM myTable
WHERE myDateTime = varDate
Before you say it I have done CreateODBCDate(varDate) :-)
SELECT *
FROM myTable
WHERE
]]
Sent: Thursday, March 30, 2000 10:45 AM
To: CF-Talk List (E-mail)
Subject: querying date in a date-time field.
Hi!
I've posted this question a couple of times in one form or another, so I'd
really appreciate an answer this time.
I've got a date time field in A SQL DB and it contains
3 matches
Mail list logo