Return hte HOUR from a TIME field in Valentina 1.1

[Ruslan Zasukhin]

On 10/8/08 7:03 AM, "Barry G. Sumpter" <barry at noodlebox.com.au> wrote:

Hi Barry,

> Hi all,

Anyone know how to return the HOUR from a TIME field in Valentina
> 1.1?


This DOES NOT work:
(Where TimeOfSale is a TIME field)

SELECT
> HOUR(TimeOfSale) from mySalesTable





Valentina 1.x was not able to have expressions in the SELECT.
You need to use BaseObject method to get this,
I.e. You create in the table one more field and give
formula as HOUR(TimeOfSale)

> I created a record at 14:27 but the
> TimeOfSale is displaying 02:27:13 WITHOUT the AM/PM designation.


Any
> Suggestions?

And how you have create it ?

-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]