How to convert Date to DateTime format
Hi,
How to convert the date string to DateTime format
please find the below example
EX:
Date1= 20160427
Date2=20160423T040000.000 GMT
I need to convert Date1 format to Date2 format.
Please suggest me how to achive this.
Thanks
Pramod
Accepted Solution
Updated: 20 Apr 2016 13:56 EDT
Process 360
IN
Hi Pramod,
I am not sure if this is of any help to you but do check this OOTB RUF
@DateTime.addToDate(Param.InputDate,0,0,0,0)
Updated: 20 Apr 2016 13:37 EDT
Pegasystems Inc.
US
Many versions of Pega ship with Joda Time included: Joda-Time - Home
You can initialize a Joda DateTime (DateTime (Joda time 2.2 API)) using your input format:, and use a Joda DateTimeFormatter (DateTimeFormatter (Joda time 2.2 API)) to print out the date in your desired format which you construct using a DateTimeFormat object (DateTimeFormat (Joda time 2.2 API)).
Due to your input format not adhering to a standard that joda understands, you MUST get your DateTime object this way:
org.joda.time.DateTime dt = org.joda.time.format.DateTimeFormat.forPattern("YYYYMMdd").parseDateTime(inputStr);
Accepted Solution
Updated: 20 Apr 2016 13:56 EDT
Process 360
IN
Hi Pramod,
I am not sure if this is of any help to you but do check this OOTB RUF
@DateTime.addToDate(Param.InputDate,0,0,0,0)
MCET
IN
n oracle SQL - PRPC_READ_FROM_STREAM() function I am getting values in this format "yyyyMMddtHHmmss.SSS zzz". how to convert this into YYYY-DD-MM HH:MI:SS in oracle sql.
