DATE CONVERSION

Saama · Post by **Saama** » Tue Jan 23, 2007 1:29 pm

Hi,
Like in server version, date conversion functions like ICONV AND OCONV handle the conversions from one format to another.
I want to convert from dd-mm-yy format to yy-mm-dd format.

please Gurus help me.

cheers;
vijay

DSguru2B · Post by **DSguru2B** » Tue Jan 23, 2007 1:32 pm

String_to_Date() function

velagapudi_k · Post by **velagapudi_k** » Tue Jan 23, 2007 1:35 pm

See if this helps
OConv("IConv("DATE",D-DMY)",D-YMD)
where date is the date value you pass.

Saama · Post by **Saama** » Tue Jan 23, 2007 1:42 pm

Hi Gurus,
Sorry my query was unclear.
I mean there are date handling function in server edition, Iconv and Oconv functions are not in the parallel version. In such case how to convert from dd-mm-yy to yy-mm-dd format in parallel version.

cheers;
vijay

I_Server_Whale · Post by **I_Server_Whale** » Tue Jan 23, 2007 1:45 pm

velagapudi_k wrote:See if this helps
OConv("IConv("DATE",D-DMY)",D-YMD)
where date is the date value you pass.

Venkat, Iconv and Oconv are not available in PX.

velagapudi_k · Post by **velagapudi_k** » Tue Jan 23, 2007 1:47 pm

I am sorry. Might have overlooked something.

I_Server_Whale · Post by **I_Server_Whale** » Tue Jan 23, 2007 1:47 pm

Saama wrote:Hi Gurus,
Sorry my query was unclear.
I mean there are date handling function in server edition, Iconv and Oconv functions are not in the parallel version. In such case how to convert from dd-mm-yy to yy-mm-dd format in parallel version.

cheers;
vijay

Your question was answered by DSguru2B. Scroll up.

narasimha · Post by **narasimha** » Tue Jan 23, 2007 1:57 pm

If you are just looking for dd-mm-yy to yy-mm-dd format, you can try to manipulate it as a string too.