How to convert date formats?

[Avraham_Yerachmielbenzvi]

H Dora,

I live in South Africa and our date Time format is dd/mm/yyyy hh:mm:ss

I got this funny message

Sorry to be so picky

Argument to MakeInstant should have form MM/dd/YYYY hh:mm:ss, or MM/dd/YYYY or hh:mm

MySQL captured the date in aytomatic but in the WRONG format

What to do?

Thanks

[Rogerio_Rios (Professional Support)]

@Avraham_Yerachmielbenzvi

MySQL captured the date in

What does capture mean?
Insert Into ?
or
Select ?
There is a huge amount of research material about MySQL.
Did you research it?

[Avraham_Yerachmielbenzvi]

@Avraham_Yerachmielbenzvi

MySQL captured the date in aytomatic

Hi,

I mean that MySQL does an auto insert of the DateTime and it dictates the format, not me???

MySQL uses yyyy-mm-dd format for storing a date value. This format is fixed and it is not possible to change it. For example, you may prefer to use mm-dd-yyyy format but you can’t. Instead, you follow the standard date format and use the DATE_FORMAT function to format the date the way you want.

[Rogerio_Rios (Professional Support)]

@Avraham_Yerachmielbenzvi

mean that MySQL does an auto insert

Well ,You know how to do it ?
I know how Mysql works​
Search more about…

So…
What’s the problem ?🤷

[Avraham_Yerachmielbenzvi]

No I dont. That’s the problem.

[Taifun]

@Avraham_Yerachmielbenzvi

I live in South Africa and our date Time format is dd/mm/yyyy hh:mm:ss

I got this funny message

Sorry to be so picky

Argument to MakeInstant should have form MM/dd/YYYY hh:mm:ss, or MM/dd/YYYY or hh:mm

You have to convert the format from MySQL into the format, which is required by the Make Instant method… just use the join block together with several segment blocks…

Taifun

[Avraham_Yerachmielbenzvi]

You are a genius, Thanks

[Tekwizer (ArnaV Bhardwaj)]

Why don’t you mark @Taifun’s post as solution instead of yours…