How do I exact a Time from a DateTime Field?

[Mailpack]

In the AS/400 Database, I have several DateTime fields.

I need to be able to Extract the time portion for Calculation Purposes.

There is a Datetime to Date function, but not DateTime to Time?

Regards

Roger Pearson

 

[drlex]

For calculations, I use

[i]mydate[/i] - datetime-to-date([i]mydate[/i])

to give a value (mydate being a datetime field)

If it's for inclusion in a string, then the number-to-string-padded function in combination with the hour or minute function gives a satisfactory result.


soi la, soi carré

 

[Mailpack]

Thank you very much.

That hit the spot !!

Regards

Roger Pearson