RE: Populate date data type from SQLServer

["Elvis Budimlic" <ebudimlic@xxxxxxxxxxxxxxxxxxxxxxxxx>]

Data formats you've shown are not DATEs, they're TIMESTAMPs.  In SQL Server
world this data type is known as DateTime.

Sounds like you want to cast DateTime from SQL server to DECIMAL(8,0).  Is
that correct?

Here's an example how you could cast a TIMESTAMP value on the IBM i:

SELECT                                                        
DECIMAL(REPLACE(CHAR(DATE(current_timestamp),ISO),'-',''),8,0)
FROM sysibm/sysdummy1

As for SQL Server... I don't know the exact syntax, but something like this
should get your SQL Server guys' creative juices going:

SELECT NUMERIC(REPLACE(CONVERT(VARCHAR(10),GETDATE(),111),'/',''),8,0)

HTH, Elvis

Celebrating 11-Years of SQL Performance Excellence on IBM i, i5/OS and
OS/400
www.centerfieldtechnology.com


-----Original Message-----
Subject: Populate date data type from SQLServer

We are uploading data from our SQL server data base.
Our files all store the date 8/0 - the standard is no date data type.
 
The guys on the dotnet side tried to convert the SQLServer date data type
column to 8/0 with no luck, so far.
I thought I'd change mine [entirely against our standards] and use the date
data type.
 
This is what I see in our file using WRKDBF before a record is populated:
0001-01-01-00.00.00.000000
This is what the server guys are trying to send:                  2008-05-12
10:34:48.400  and no - between the date and time.
Any suggestions?
Thanks,
 
 
Fran Denoncourt