HP3000-L Archives

February 2000, Week 4

HP3000-L@RAVEN.UTC.EDU
Options: Use Monospaced Font
Show Text Part by Default
Show All Mail Headers

Message: [<< First] [< Prev] [Next >] [Last >>]
Topic: [<< First] [< Prev] [Next >] [Last >>]
Author: [<< First] [< Prev] [Next >] [Last >>]

Print Reply
Subject:
Re: Moving Dates - Image/SQL
From:
Peter Chong <[log in to unmask]>
Reply To:
Peter Chong <[log in to unmask]>
Date:
Thu, 24 Feb 2000 13:43:09 -0800
Content-Type:
text/plain
Parts/Attachments:
text/plain (34 lines) 
Hi, Kevin

I presume Date/Time for a PC.

For the PC Date/Time , I use IMAGE for I2 for Date, 
It will populates since 1900-Jan-1st like 
365.25 * Year + Days on a Year
and Time for X8 to popllate like "12:07:59"..

Cheers


Peter Chong
Sr. ERP/MRP Analyst.
L3 Communications
714.956.9200 x 363
http://www.powerparagon.com

>>> "Kevin J. Mullins" <[log in to unmask]> 02/24/00 08:11AM >>>
We could use a bit of help here...

What should the Cobol storage format of a date field be in Image/SQL so that
we can TYPE the field as a date field in Image/SQL? What should be the Image
definition of the field in the schema as well?

TIA for your assistance.

************************************************************************
Kevin J. Mullins          Phone:  281-376-8953
MIS Manager             Fax:      281-469-3226
Interconex, Inc.          E-mail:  [log in to unmask] 
Houston, TX, USA      URL:     http://www.interconex.com 
************************************************************************

ATOM RSS1 RSS2