Date Reformat AM/PM

More

7 years 2 months ago #15473 by DeanCovey

Date Reformat AM/PM was created by DeanCovey

I always struggle with these. This looks like 11:00 AM in my SQL db when it't really 11:00 PM. How do I fix?

Attachments:

Please Log in or Create an account to join the conversation.

More

7 years 2 months ago #15474 by admin

Replied by admin on topic Date Reformat AM/PM

I think you are using incorrect format for time because you have zeros (04)

M/D/YYYY HH:NN:SS TT is more appropriate

Mike
ETL Architect

Please Log in or Create an account to join the conversation.

More

7 years 2 months ago #15475 by DeanCovey

Replied by DeanCovey on topic Date Reformat AM/PM

I changed the formatting as you suggested. The results seem to be the same.

Attachments:

Please Log in or Create an account to join the conversation.

More

7 years 2 months ago #15476 by admin

Replied by admin on topic Date Reformat AM/PM

Yes there is definitely something wrong with it, we are looking at it now :unsure:

Mike
ETL Architect

The following user(s) said Thank You: DeanCovey

Please Log in or Create an account to join the conversation.

More

7 years 2 months ago #15477 by DeanCovey

Replied by DeanCovey on topic Date Reformat AM/PM

Good to know. Thought it was just me.

Please Log in or Create an account to join the conversation.

More

7 years 2 months ago #15478 by admin

Replied by admin on topic Date Reformat AM/PM

Dean Can you try latest version please.

Mike
ETL Architect

Please Log in or Create an account to join the conversation.