Re: how to use date in SQL Select

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Heikki Lehto (heikki.lehto_at_nokia-eu.com)
Date: 04/19/04 

Date: Mon, 19 Apr 2004 20:17:26 +0300

> Select * from myDsn Where junk = 'abc' AND DateAdd("s", sValue,
#1/1/1970#)
> = '4/19/2004'

solved it by creating a timecalculation for seconds before midnight and
passed that value to the sqlCommand string , ie "Select * from myDsn Where
junk = 'abc' AND time_stamp >= " & myCalculatedSeconds

works fine!:)