Level 102
It's a varchar not a date column, so use substring
SUBSTRING(datacompleta, 0, 4) AS mes
Nov 29, 2022
4
Level 1
date field in varchar how to extract year from year_month mysql laravel
hello, i have the following field in varchar. "mes" how do i extract or get the year only from that year_month ? i tried this in multiple synthaxes and use the year() and none of them worked. " EXTRACT(YEAR_MONTH FROM datacompleta) AS mes "
Level 73
Why are you storing a date as varchar?
Level 1
@Tray2 i'm not sure i haven't look much into it, but i guess it's because the blade file has a type as "month" and when i tried changing to date format on phpmyadmin, it didn't load the view, against varchar wich it did. im also using datetime-local in other fields and they work but this specific one of month i need to extract the year on a separate page.
Level 73
@peterpan26 You really should use timestamps or date time, then it's one field for the whole date.
I suggest reading this post about data types and some other database things.
Please or to participate in this conversation.