GeekInterview.com
Series: Subject: Topic:
Question: 72 of 207

Explain about CHAR function and it's use in DB2

Asked by: Interview Candidate | Asked on: Feb 7th, 2007
Showing Answers 1 - 3 of 3 Answers

Char function returns a character format of date or time.

  
Login to rate this answer.
kalone

Answered On : Feb 1st, 2010

View all answers by kalone

If we want to concatenate date or time values to some text ,then we have to convert those values to string char first ,for this in DB2 we have CHAR() function.
Eg.   CHAR(CURRENT DATE)

  
Login to rate this answer.
yuvaevergreen

Answered On : Mar 26th, 2010

View all answers by yuvaevergreen

Returns a fixed-length character string representation of

  • Datetime
  • Character
  • Integer
  • Decimal
  • Floating-point number
  • Row ID

  
Login to rate this answer.

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

Related Open Questions

Ads

Connect

twitter fb Linkedin GPlus RSS

Ads

Interview Question

 Ask Interview Question?

 

Latest Questions

Interview & Career Tips

Get invaluable Interview and Career Tips delivered directly to your inbox. Get your news alert set up today, Once you confirm your Email subscription, you will be able to download Job Inteview Questions Ebook . Please contact me if you there is any issue with the download.