Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
Datatype DATETIME

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
richie

New User


Joined: 11 Jun 2005
Posts: 24

PostPosted: Wed Oct 26, 2005 7:12 pm    Post subject: Datatype DATETIME
Reply with quote

Hi,

Please tell me how to use DATETIME datatype in order to extract date part.Please let me know the format to be used in Workign storage to extract date and whether we can use UNSTRING function to seperate Date and time part.


Thanks.
Back to top
View user's profile Send private message

Rameshs

New User


Joined: 15 Jun 2005
Posts: 53
Location: India, Chennai

PostPosted: Thu Oct 27, 2005 4:20 pm    Post subject:
Reply with quote

hi,

you can use the db2 function DATE, TIME to extract date, time from timestamp data type.

(e.g)

EXEC SQl
Select date(current timestamp) into :ws-date from sysibm.sysdummy1
END-EXEC
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Select numeric portion from CHAR data... balaji81_k DB2 6 Sat Aug 19, 2017 1:51 am
No new posts Sticky: CICS Program "DATETIME" Bill O'Boyle CICS 3 Mon Nov 11, 2013 8:42 pm
No new posts Converting Datatype while adding the ... dsivapradeep DFSORT/ICETOOL 6 Mon Nov 11, 2013 11:17 am
No new posts DB2 V10 upgrade - DATETIME builtin fu... yogi.47eie DB2 2 Sat Jul 13, 2013 11:10 am
No new posts PL/I builtin function DATETIME ramsri PL/I & Assembler 13 Wed Feb 08, 2012 11:43 pm

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us