IBM Mainframe Forum Index
 
Register
 
IBM Mainframe Forum Index Mainframe: Search Log in to check your private messages Log in
 

DB2 V10 upgrade - DATETIME builtin function change


 
IBM Mainframe Forums -> DB2
Post new topic   Reply to topic
View previous topic :: :: View next topic  
Author Message
yogi.47eie

New User


Joined: 16 Aug 2006
Posts: 40
Location: india

PostPosted: Sat Jul 13, 2013 11:10 am
Reply with quote

Hi All,
We are going thru the DB2 V10 changes and could see the statement as
"In DB2 Version 10 conversion mode (from Version 8 or Version 9.1), the following additional string formats are allowed in the specified limited contexts:
1. A string value of seven characters representing a date is allowed as an argument to the DATE function only.
2. A string value of 8, 13, or 14 characters representing a point in time is allowed as an argument to the TIMESTAMP function only."

Can you help me what actually they are referring 7 character of DATE function . Also the second point also little bit confusing me. Any help is much appreciated .I have goolge it & hardly didn't find 7 character representation of date
Back to top
View user's profile Send private message
Nic Clouston

Global Moderator


Joined: 10 May 2007
Posts: 2429
Location: Hampshire, UK

PostPosted: Sat Jul 13, 2013 1:50 pm
Reply with quote

Instead of googling did you go directly to the SQL Lang. Ref manuals?
Back to top
View user's profile Send private message
yogi.47eie

New User


Joined: 16 Aug 2006
Posts: 40
Location: india

PostPosted: Sat Jul 13, 2013 2:39 pm
Reply with quote

Hi Nic,
I was able to see 8 character representation of date in IBM manuals .. that's why confused
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic All times are GMT + 6 Hours
Forum Index -> DB2
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Forum Replies
No new posts DB2 - row_number function - Need 1st ... DB2 5
No new posts How to Assign a Function key to Mainf... TSO/ISPF 4
No new posts Rexx STRIP Equivalent function in CLIST CLIST & REXX 5
No new posts OUTTRAP Equivalent function in CLIST CLIST & REXX 5
No new posts ADDMONS function - conclusion after o... SYNCSORT 1

Back to Top