Try wrapping the field with DATE() and TIME() as in DATE(timestampfield) and

-----Original Message-----
From: MIDRANGE-L [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Jack
Sent: Monday, July 21, 2014 7:49 PM
To: 'Midrange Systems Technical Discussion'
Subject: Sql View

I posted originally about adding edit codes to a table created using SQL. I
understand that I can't do that.

How can I create a view that gives me separate date and time fields for a
time stamp? I would like all of the fields in the file and the two new

I've been googling but haven't figured it out yet.

Thanks, Jack

This email is free from viruses and malware because avast! Antivirus
protection is active.
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,
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a
moment to review the archives at

Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2015 by MIDRANGE dot COM and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available here. If you have questions about this, please contact