Member Avatar for milan.sabic

Hello

I have a mysql table with 2 columns, Id and date. How can I insert one more
Column "dayname" that will be filled through sql query with day names related to
The value in the column "date".

Thanks

  • 2 Contributors
  • 2 Replies
  • 76 Views
  • 20 Minutes Discussion Span
  • Latest Post Latest Post by milan.sabic
Member Avatar for pritaeas

There's no need, check the DAYNAME function.

Member Avatar for milan.sabic

So if a column type is DAYNAME it will automatically do it.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.