RE: Timestamps querying question

2002-04-14 Thread Ben Holness
> It is not apparent from your question, where the problem lies. Why not > show us what you have so far? > SQL is used to retrieve data from relational databases. Are you really > intending to retrieve FROM a web page? Sorry, I meant that I am writing a PHP web page that takes input from a user t

Re: Timestamps querying question

2002-04-14 Thread DL Neil
Hi Ben, > I have a database table which includes a timestamp(14) field. > > I would like to construct an SQL statement that pulls out records between > two dates, based on this field (i.e. time is not important, date is). > > So a user input "01/01/2001" -> "01/01/2002" and I want to retrieve all

Timestamps querying question

2002-04-14 Thread Ben Holness
Hi all, I have a database table which includes a timestamp(14) field. I would like to construct an SQL statement that pulls out records between two dates, based on this field (i.e. time is not important, date is). So a user input "01/01/2001" -> "01/01/2002" and I want to retrieve all records t