Re: AW: Converting zoned field to a TIME value in SQL

Thanks everyone. And yes, Rob, i do..........

Michael Kirkpatrick
Western Dental Services, Inc.
Information Systems / System i Development
(
Phone:
(714) 571.3582
(
Toll free:
(800) 471.4444
7
Fax:
(714) 480.3001
*
Email:
mkirkpatrick@xxxxxxxxxxxxxxxxx
8
Web:
http://www.westerndental.com/





"BirgittaHauser" <Hauser@xxxxxxxxxxxxxxx>
Sent by: midrange-l-bounces@xxxxxxxxxxxx
08/15/2007 11:30 AM
Please respond to
Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>


To
"'Midrange Systems Technical Discussion'" <midrange-l@xxxxxxxxxxxx>
cc

Subject
AW: Converting zoned field to a TIME value in SQL






Hi,

You first have to convert your numeric time into a valid character
representation of a time and then either use the scalar function TIME or
CAST to convert the character representation into a real time:

Select Cast(Substr(Digits(MyNumTime), 1, 2) concat '.' concat
Substr(Digits(MyNumTime), 3, 2) concat '.' concat
Substr(Digits(MyNumTime), 5, 2) as Time) as MyTime

From MyTable

Mit freundlichen Grüßen / Best regards

Birgitta Hauser

"Shoot for the moon, even if you miss, you'll land among the stars." (Les
Brown)

"If you think education is expensive, try ignorance." (Derek Bok)

"What is worse than training your staff and losing them? Not training
them
and keeping them!"



-----Ursprüngliche Nachricht-----
Von: midrange-l-bounces+hauser=sss-software.de@xxxxxxxxxxxx
[mailto:midrange-l-bounces+hauser=sss-software.de@xxxxxxxxxxxx] Im Auftrag
von MKirkpatrick@xxxxxxxxxxxxxxxxx
Gesendet: Wednesday, August 15, 2007 20:18
An: Midrange Systems Technical Discussion
Betreff: Converting zoned field to a TIME value in SQL


I have reviewed the archives but could not really find an answer.

How do I convert a zoned (6,0) field to a TIME value using SQL? I want to

do this in a view.

Thanks for your help.





This email and any files transmitted with it are confidential and intended
solely for the use of the individual or entity to whom they are addressed.
Unless you are the addressee (or authorized to receive for the addressee),
you may not use, copy or disclose to anyone this email or any information
contained in this email. If you have received this email in error, please
advise the sender by replying to this email, and delete this email
immediately. Please note that any views or opinions presented in this
email
are solely those of the author and do not necessarily represent those of
Western Dental Services, Inc. Finally, the recipient should check this
email and any attachments for the presence of viruses. Western Dental
Services, Inc. accepts no liability for any damage caused by any virus
transmitted by this email.