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: 2455
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: 1351
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: 2803
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 DSNTIAUL and DB2 scalar functions DB2 3
No new posts SORT for dynamic trailer record + CSV... DFSORT/ICETOOL 14
No new posts Date conversation DFSORT/ICETOOL 6
No new posts To pull the file with Date and Time u... TSO/ISPF 17
No new posts Help this REXX Rookie-Bad arithmetic ... CLIST & REXX 7
Search our Forums:

Back to Top