Home » RDBMS Server » Server Administration » Re: Help on Date type with OO4O
Re: Help on Date type with OO4O [message #370255] Wed, 14 July 1999 08:53
Chris Hunt
Messages: 27
Registered: March 1999
Junior Member
What's 0040? To get the hour from a DATE field, use the expression TO_CHAR(my_date,'HH24'). You might want to enclose this in a TO_NUMBER function too.

Previous Topic: Re: To_Date Function
Next Topic: within a trigger, trying to select values into variables based on the trigger statement
Goto Forum:
  


Current Time: Wed Oct 28 07:11:42 CDT 2020