×
The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.
Jack,
Just add this as a column expression in the View.
Timestamp(ENTRYDT, Insert(Digits(ENTRYTM),3,0,'.') Concat '.00') As ENTRYTS
Jim
________________________________
From: MIDRANGE-L <midrange-l-bounces@xxxxxxxxxxxx> on behalf of Jack Tucky <jacktucky@xxxxxxxxx>
Sent: Friday, September 29, 2017 8:53 PM
To: Midrange Systems Technical Discussion
Subject: SQL Create View Timestamp
I'd like to try to create a view so that I can make a timestamp field. I
have an existing PF with an ISO date and a 4 digit numeric time. How can I
create a view that will give me a timestamp?
The table is WHSSN00 and the field names are ENTRYDT and ENTRYTM.
Thanks, Art (Still googling and experimenting)
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit:
https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at
https://archive.midrange.com/midrange-l.
Please contact support@xxxxxxxxxxxx for any subscription related questions.
Help support midrange.com by shopping at amazon.com with our affiliate link:
http://amzn.to/2dEadiD
midrange.com
