Can anyone help me with SQL-89 functions, I am looking for something that will return the current date (I know how to do this with SQL-92, but not SQL-89) also if there are any other available functions for SQL-89 any help with be great.
What I am trying to do is filter a SQL statement on a character field called TimeStamp, it is filled with a string that is a date formatted as YYYY-MM-DDThh:mm:ss, so in my query I want to return records
WHERE Timestamp BETWEEN 2011-09-09T00:00:00 and 2011-09-09T01:00:00 where those times are now, and one hour ago.
Any help would be great.
What I am trying to do is filter a SQL statement on a character field called TimeStamp, it is filled with a string that is a date formatted as YYYY-MM-DDThh:mm:ss, so in my query I want to return records
WHERE Timestamp BETWEEN 2011-09-09T00:00:00 and 2011-09-09T01:00:00 where those times are now, and one hour ago.
Any help would be great.