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.

Report message to a moderator

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

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Apr 19 10:53:28 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.