Informatica - convert date format in Informatica

GeekInterview.com > Tech FAQs > Informatica

Go To First | Previous Question | Next Question

Informatica | Question 212 of 312

convert date format in Informatica

I have a requirement to convert date format.my requirement is as follows
i hav date column in my source.my source data in date column
v_date
10-11-2006
19-aug-1999
25-dec-05
null
11-5-05
like this
my requirement is,it has to send me the output as dd-mon-yyyy like 26-nov-2006.if in v_date column required format is not there it has to convert it the correct format,if the record is in the correct format it has to send as it is & if in date column if the record is null it has to replace it with sysdate.how can i do?can any one help me out

Total Answers and Comments: 1

Last Update: September 13, 2007 Asked by: suneetharoy

JavaScript Date Object

JavaScript Date Object In this JavaScript tutorial you will learn about date object and methods of date object explained along with syntax and example mosgoogle center JavaScript Date Object Usage of Date Object Date object of Java Script is used to work with date and times General syntax for defini

Convert a String into an Integer

How to convert a string into an integer in C program? This is done by using the function named as atoi(). This function atoi() is present in the header file named as <stdlib.h>. When programmers use this function they must include the header file by the statement #include <stdl

Convert a String into Long Value

What string function is used to convert a string into long value? This is done by using the function named as atol() . This function atol() is present in the header file named as <stdlib.h>. When programmers use this function they must include the header file by the statement

What are the Format Specifiers used with printf?

There are several format specifiers available in printf. The format specifier used varies depending on the data type used for printing. The given below are some of the format specifiers used with printf in C program. For integer data type the format specifier used with printf is %d or %i For float

Choosing The Best Format For Your Resume

Writing a resume can be stressful enough, but when you do a little bit of research you can get even more stressed when you realize that there are several different resume styles that may or may not apply to you.  Yikes!  Luckily, all of these different resume types can be broken do

Choosing The Best Format For Your Resume

Choosing The Best Format For Your Resume Writing a resume can be stressful enough but when you do a little bit of research you can get even more stressed when you realize that there are several different resume styles that may or may not apply to you mosgoogle Yikes Luckily all of these different re