Elvis,
Yes, that is exactly what I am trying to get done... except we don't do SQL here. We need it from the server.
I'll ask the server guy to look at this.
Thank you,
"Elvis Budimlic" <ebudimlic@xxxxxxxxxxxxxxxxxxxxxxxxx> 05/13/2008 2:30 PM >>>
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
midrange.com
