RE: Timestamp in query

Thanks Rob.  I've probably seen this many times but needed it spelled out
for me.

-----Original Message-----
From: rob@xxxxxxxxx [mailto:rob@xxxxxxxxx]
Sent: Thursday, October 13, 2005 2:10 PM
To: Midrange Systems Technical Discussion
Subject: Re: Timestamp in query


Result fields
Field       Expression 
MYTSCHAR    char(myts) 
MYYEARCHAR  substr(mytschar,1,4)

Select fields
Seq   Field             Text 
  10  MYTS 
  20  MYYEARCHAR        substr(mytschar,1,4)
      MYTSCHAR          char(myts) 

....+....1....+....2....+....3....+...
MYTS                        MYYEARCHAR
2005-10-13-14.07.00.271936     2005 
********  End of report  ******** 


Rob Berendt