 | |
#11
 
| |||
| |||
|
Re: TimeStamp -
01-30-2008
, 12:02 AM
|
FeedingFrenzy1... (AT) gmail (DOT) com wrote: 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? Thanks, FF 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:http://download.oracle.com/docs/cd/B.../b14200/sql_el... -- Regards, Frank van Bortel Top-posting in UseNet newsgroups is one way to shut me up |
I have a field called Time_end in my database which has the TimeStamp
datatype.
i am trying to get input from the user in a textbox
txtDate.Text = Format(txtDate.Text, "dd-mmm-yyyy")
Now i want to get all the values in my time_end field which were on
the same date.
How do i do this?
Thanks
select * form mytable where thedate>= to_date(txtDate.Text,'dd-mon-yyyy')
and
thedate<=(to_date(txtDate.Text,'dd-mon-yyyy') +1)
Remember to use bind variables in your queries
Jim
#12
| |||
| |||
|
|
FeedingFrenzy1... (AT) gmail (DOT) com wrote: 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? Thanks, FF 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:http://download.oracle.com/docs/cd/B.../b14200/sql_el... -- Regards, Frank van Bortel Top-posting in UseNet newsgroups is one way to shut me up |
I have a field called Time_end in my database which has the TimeStamp
datatype.
i am trying to get input from the user in a textbox
txtDate.Text = Format(txtDate.Text, "dd-mmm-yyyy")
Now i want to get all the values in my time_end field which were on
the same date.
How do i do this?
Thanks
select * form mytable where thedate>= to_date(txtDate.Text,'dd-mon-yyyy')
and
thedate<=(to_date(txtDate.Text,'dd-mon-yyyy') +1)
Remember to use bind variables in your queries
Jim
#13
| |||
| |||
|
|
FeedingFrenzy1... (AT) gmail (DOT) com wrote: 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? Thanks, FF 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:http://download.oracle.com/docs/cd/B.../b14200/sql_el... -- Regards, Frank van Bortel Top-posting in UseNet newsgroups is one way to shut me up |
I have a field called Time_end in my database which has the TimeStamp
datatype.
i am trying to get input from the user in a textbox
txtDate.Text = Format(txtDate.Text, "dd-mmm-yyyy")
Now i want to get all the values in my time_end field which were on
the same date.
How do i do this?
Thanks
select * form mytable where thedate>= to_date(txtDate.Text,'dd-mon-yyyy')
and
thedate<=(to_date(txtDate.Text,'dd-mon-yyyy') +1)
Remember to use bind variables in your queries
Jim
 |
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.