Date: Tue, 29 Jan 2008 20:48:21 +0100
> Hi all,
> I am trying to construct a query tool in VB6.
> This is all i want my query to perform:
> Select * from table where timestamp_field = Date.text
> Any help?
Timestamps in oracle are not text - their representation
on screen is. Dates are just like that, but have less
resolution (1 second for date, 1 nanosecond (10^-9 sec)
for a timestamp).
Having said that - the representation depends on what format you have defined to show timestamps in. There's always a default, so you'll always see 'something'.
Relying on the default format mask is a dangerous thing
to do - therefor, always do an explicit conversion:
select * from table
where timestamp = to_timestamp(date.text,'format_mask'); format_mask is the generic text representation of how your Date.text looks like.
Definition of format masks for datetime elements can be found in the SQL Reference manual on tahiti.oracle.com, specifically:
-- Regards, Frank van Bortel Top-posting in UseNet newsgroups is one way to shut me upReceived on Tue Jan 29 2008 - 13:48:21 CST