It is currently Sat Sep 04, 2010 1:42 pm


Post new topic Reply to topic  [ 1 post ] 
Author Message
 Post subject: Date retrieval format from Db2 using SAS
PostPosted: Wed Apr 28, 2010 6:15 am 
Offline

Joined: Mon Apr 26, 2010 9:17 pm
Posts: 2
Antispam: No
The second last number please: 7
Kids: pencil
When I try to retrieve a date fields from a DB2 table through SAS, the date format is coming as
19JAN2010(sample one).

But a similar query from a different table is showing the retrieved date as 18304.

I need to compare these 2 dates for my processing.

How can I make the date 19JAN2010 to 18304 format so that i can process.
or Is there a way to change the 18304 format to 19JAN2010 format?

Please help.


Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 1 post ] 

All times are UTC - 8 hours [ DST ]


Who is online

Users browsing this forum: No registered users and 1 guest


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  
cron