June 11, 2015 at 4:57 am
Hi,
I have created one variable name migration_start datetime
which give me default format of 6/11/2015 1:26 AM
But I expecting to get in 2015-06-11 01:26:22.813 format.
kindly suggest me the expression.
Regards,
Vipin jha
June 11, 2015 at 5:06 am
vipin_jha123 (6/11/2015)
Hi,I have created one variable name migration_start datetime
which give me default format of 6/11/2015 1:26 AM
But I expecting to get in 2015-06-11 01:26:22.813 format.
kindly suggest me the expression.
Regards,
Vipin jha
What have you tried so far?
The absence of evidence is not evidence of absence.
Martin Rees
You can lead a horse to water, but a pencil must be lead.
Stan Laurel
June 11, 2015 at 5:11 am
Hi ,
I have used below expression betting getting issue with that
(DT_STR, 4, 1252) DATEPART("yyyy" , @[User::migration_start]) + "-" + RIGHT("0" + (DT_STR, 2, 1252) DATEPART("mm" , @[User::migration_start]), 2) + "-" + RIGHT("0" + (DT_STR, 2, 1252) DATEPART("dd" , @[User::migration_start]), 2)
Regards,
Vipin Jha
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply