Menu ▾ ▴

#1258 DATE_FORMAT output formatting issue

Upstream
nobody
None
Defect
2009-07-20
2009-07-13
Anonymous
No

Originally created by: akau...@gmail.com

What exact steps will reproduce the problem?
RUN select date_format(now(), "%m-%d-%Y") as dte

What was the expected output?
A formatted date

What happened instead?
Get a hex value 0x30372D31332D32303039

Suggested fix (optional)?

Version used?
HeidiSQL revision: 4.0 Rev 2517
MySQL Server version: 5.0.27
Operating system: Fedora

Discussion

  • Comment has been marked as spam. 
    Undo

    View and moderate all "tickets Discussion" comments posted by this user

    Mark all as spam, and block user from posting to "Tickets"

    Anonymous

    Anonymous - 2009-07-15

    Originally posted by: a...@anse.de

    This is a bug in the server. See issue #718 .

    Status: Upstream

     

    Related

    Tickets: #718

  • Comment has been marked as spam. 
    Undo

    View and moderate all "tickets Discussion" comments posted by this user

    Mark all as spam, and block user from posting to "Tickets"

    Anonymous

    Anonymous - 2009-07-20

    Originally posted by: akau...@gmail.com

    Sorry - npt sure how it is related to #718 - that is a AES Encrypt format - this is a
    simple formatted date - how are they related?

     
  • Comment has been marked as spam. 
    Undo

    View and moderate all "tickets Discussion" comments posted by this user

    Mark all as spam, and block user from posting to "Tickets"

    Anonymous

    Anonymous - 2009-07-20

    Originally posted by: akau...@gmail.com

    Got it - solution is use CONVERT(date_format(now(), "%m-%d-%Y") USING utf8) AS DTE
    instead