Hi,
I have create a column name EFFT_DT (DATE) and i enter 2011-04-03 in dummy flat file in notepad but its showing values like 40240 in sequential when i try to view data.i want 2011-04-03.Can someone helps me on this.
date value
Moderators: chulett, rschirm, roy
Re: date value
Share the settings you made in the Sequential file stage?
Thanks
Ram
----------------------------------
Revealing your ignorance is fine, because you get a chance to learn.
Ram
----------------------------------
Revealing your ignorance is fine, because you get a chance to learn.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Date data type will be converted to an internal format when processed by the import operator. How are you determining that the value is 40240? (Don't believe everything you read in newspapers or the data browser.)
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
hi sura,
here is sequential file settings
Record level
Final delemiter :none
Field level
Delemiter : |
Quote :none
Hi ray,
I get to know that value of date when i copy the records from spreadsheet to notepad in notepad its showing that values wheres i enter the yyyy-mm-dd format in spreadsheet.I use spreadsheet for creating file
here is sequential file settings
Record level
Final delemiter :none
Field level
Delemiter : |
Quote :none
Hi ray,
I get to know that value of date when i copy the records from spreadsheet to notepad in notepad its showing that values wheres i enter the yyyy-mm-dd format in spreadsheet.I use spreadsheet for creating file
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 96
- Joined: Mon May 14, 2012 1:30 pm