Announcement

Collapse
No announcement yet.

MYSQL MONTHNAME() Problem

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • MYSQL MONTHNAME() Problem

    "SELECT MONTHNAME(`samedate`) AS aMonthName FROM somedb'

    works as expected in the SQL builder and other systems I use, it returns the month name - Januray, February etc..

    In SC8 grid and forms only numbers (ie 1, 2 etc) are shown.

    Any ideas, or is it another SC feature I should just learn to adapt to?

    PS: I switched to manual lookup.
    The GuiGuy
    ... from Down Under
Working...
X