Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Custom Expression Function: ParseDateTime

Given a DateTime of

10-OCT-2015 07:10 PM

How can one convert this? I've got the first part correct but it's the Time I'm having difficulty with.

ParseDateTime([column name],"dd-MMM-yyyy hh:mm")

How can AM/PM be represented?

like image 380
flux Avatar asked Feb 19 '26 18:02

flux


1 Answers

Figured it out!

ParseDateTime([Diary Date],"dd-MMM-yyyy hh:mm tt","en-US")
like image 63
flux Avatar answered Feb 21 '26 13:02

flux



Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!