Re: sql question

[Alan Campin <alan0307d@xxxxxxxxx>]

Are you talking about in SQL?

SELECT Timestamp(
       Char(aDateField,Iso) || ' ' ||
       Char(aTimeField)) ||
       '.000000')
  From YourFile



On Thu, Mar 12, 2009 at 4:52 PM, DeLong, Eric <EDeLong@xxxxxxxxxxxxxxx>wrote:

> Sure...
>
> Many ways to go about it.  One approach (that involves RPG) might be:
>
> 1> create your new file, which replaces the date and time fields with a
> single timestamp field.
> 2> write an rpg program to read from the original file, then
>
> eval myTimeStamp = oldDate + oldTime;
>
> before you write the new record format....
>
> Hth,
> Eric DeLong
>
>
> -----Original Message-----
> From: rpg400-l-bounces@xxxxxxxxxxxx
> [mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of tim
> Sent: Thursday, March 12, 2009 5:37 PM
> To: 'RPG programming on the IBM i / System i'
> Subject: sql question
>
> Not sure if this is correct forum for this but.
>
>
>
> I have a file with a date field and a time field. I would like to
> combine those fields into a date/time field. Is this possible?
>
>
>
>
>
> --
> This is the RPG programming on the IBM i / System i (RPG400-L) mailing
> list To post a message email: RPG400-L@xxxxxxxxxxxx To subscribe,
> unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
> or email: RPG400-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives at
> http://archive.midrange.com/rpg400-l.
>
>
>
> --
> This is the RPG programming on the IBM i / System i (RPG400-L) mailing list
> To post a message email: RPG400-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
> or email: RPG400-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/rpg400-l.