date pattern for mysql type /Date(1529260200000)/ RSS

• • Reply
  sidu

  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

• • Reply
  rajesh93180

  Participant

  1644 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.

  • Date Conversion in MySQL.

  Thanks,

  RajeshV.

  -Rajesh Vemunoori LinkedIn Profile
  
  Mark as answer if you find this post helpful.
• • Reply
  Nan Yu

  All-Star

  18815 Points

  3831 Posts

  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

• • Reply
  PatriceSc

  All-Star

  48670 Points

  18169 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.