Please provide more details about your scenario , Do you want to format date on output and what is the expected format ? In my sql , you can use DATE_FORMAT function
:
You already asked. As pointed in another thread it seems the problem is not on the MySQL side. Don't do the formatting on the MySQL side and work with native data until you have to show this value to a user.
The value you show seems to be a JavaScript serialized date. Do you see that value following an Ajax call or something ?
For now I believe the problem is not where you think it is.
Member
4 Points
66 Posts
date pattern for mysql type /Date(1529260200000)/
Jun 26, 2018 11:33 AM|sidu|LINK
Hi all
My date pattern is like /Date(1529260200000)/
i am useing this link , but i am not geting out put
help me
Participant
1624 Points
792 Posts
Re: date pattern for mysql type /Date(1529260200000)/
Jun 26, 2018 11:45 AM|rajesh93180|LINK
Hello sidu,
If you are using MySQL, then please check this link.
Thanks,
RajeshV.
Mark as answer if you find this post helpful.
All-Star
18265 Points
3589 Posts
Microsoft
Re: date pattern for mysql type /Date(1529260200000)/
Jun 27, 2018 05:46 AM|Nan Yu|LINK
Hi sidu ,
Please provide more details about your scenario , Do you want to format date on output and what is the expected format ? In my sql , you can use
DATE_FORMAT
function :https://www.w3schools.com/sql/func_mysql_date_format.asp
https://dev.mysql.com/doc/refman/8.0/en/date-and-time-types.html
Best Regards,
Nan Yu
MSDN Community Support
Please remember to "Mark as Answer" the responses that resolved your issue.
All-Star
43240 Points
14958 Posts
Re: date pattern for mysql type /Date(1529260200000)/
Jun 27, 2018 10:12 AM|PatriceSc|LINK
Hi,
You already asked. As pointed in another thread it seems the problem is not on the MySQL side. Don't do the formatting on the MySQL side and work with native data until you have to show this value to a user.
The value you show seems to be a JavaScript serialized date. Do you see that value following an Ajax call or something ?
For now I believe the problem is not where you think it is.