Please help to sole this task. I need convert date to char and then to number, so that i can perform arithmetic operation and divide the date by 2. This query doesn’t work and i have no idea how i can convert date to number. Answer Based on the understanding of the question I think you need the current day
Tag: data-conversion
Convert VARBINARY to Base64 in MySQL
This seems like a basic scenario, but I can’t find relevant info anywhere. I’m new to MySQL, coming from years of Microsoft SQL Server experience. In MySQL, how do you convert a BINARY or VARBINARY value into a Base64 string, and vice-versa? In Microsoft SQL Server, I’ve been using code like this: According to mysql.com, it looks like the TO_BASE64