|
|||||||||
|
|||||||||
| |||||||||
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
Dev Shed Forums Sponsor:
|
|
Stop making mediocre tutorials.The best tutorials are video! Camtasia Studio makes it easy to create engaging, buzz-building screen videos at any size, in any popular format. Download the free trial!
|
|
#1
September 16th, 2004, 08:29 AM
|
|||
|
|||
|
I can't do a query in DB Block using a date field, in developer 6i
Hi, i have little aplication, in which a i want to do a query, using a datetime field. The field in the block has this mask 'DD/MM/YYYY', but in the DB has this one 'DD/MM/YYYY HH:MM:SS'.
I've tried using 'trunc', in the field before execute the query, ( in the trigger 'Pre-Query' ) but it didn't work. How can i do it ??? 
|
|
#2
September 21st, 2004, 07:57 AM
|
|||
|
|||
|
Hi,
While retrieving value from DB use to_date(columnname,'dd/mm/yyyy') Hope this helps Regards Ankur
|
|
| Viewing: Dev Shed Forums > Databases > Oracle Development > I can't do a query in DB Block using a date field, in developer 6i |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
