IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

SUBSTR for Date functions


IBM Mainframe Forums -> DB2
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
Shaheen Shaik

New User


Joined: 05 May 2016
Posts: 13
Location: India

PostPosted: Thu Apr 06, 2017 2:14 pm
Reply with quote

Please help me out for the below query,
Can we use SUBSTR for date functions in DB2 ?
Back to top
View user's profile Send private message
Nic Clouston

Global Moderator


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

PostPosted: Thu Apr 06, 2017 2:28 pm
Reply with quote

Do you mean some entity called "SUBSTR for date functions" or use SUBSTR instead of date functions or use SUBSTR on the value returned by date functions ie can a date function be the first patrameter to SUBSTR?
What have you tried?
Back to top
View user's profile Send private message
Shaheen Shaik

New User


Joined: 05 May 2016
Posts: 13
Location: India

PostPosted: Thu Apr 06, 2017 3:04 pm
Reply with quote

Thanks for your response Nic.
Let me make my query clear.
My question is that can we use SUBSTR function to the column which holds the date in DB2 table?
ex: Select SUBSTR(join_date,1,10) from employee table

join_date has data type as DATE in the employee table

Please let me know that whether SUBSTR function is applicable for VAR/CAHR only otherwise can we use it for DATE functions as well.
Back to top
View user's profile Send private message
Marso

REXX Moderator


Joined: 13 Mar 2006
Posts: 1353
Location: Israel

PostPosted: Thu Apr 06, 2017 6:47 pm
Reply with quote

You already have date functions like:
- DAY(mydatefield)
- MONTH(mydatefield)
- YEAR(mydatefield)
What more do you need ??

Note: if SUBSTR(join_date,1,10) worked, it would return the 10 first chars of the date, which is... the date itself.
Back to top
View user's profile Send private message
Rohit Umarjikar

Global Moderator


Joined: 21 Sep 2010
Posts: 3076
Location: NYC,USA

PostPosted: Fri Apr 07, 2017 1:53 am
Reply with quote

Quote:
Please let me know that whether SUBSTR function is applicable for VAR/CAHR only otherwise can we use it for DATE functions as well.
No, unless you add CHAR on date. as Marso said why do you need that anyways? Any interview question?
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DB2

 


Similar Topics
Topic Forum Replies
No new posts Date format correction using dfsort DFSORT/ICETOOL 3
No new posts Sorting Date Field DFSORT/ICETOOL 4
No new posts CONVERT a given date from UTC TO BST CICS 0
No new posts Pull data using date difference betwe... DB2 6
No new posts CA7 count with DATE variable CA Products 0
Search our Forums:

Back to Top