Convert datetime value into string

Question

I am fetching the current date  amp  time using NOW   in mysql   I want to convert the date value into a varchar and concat it with another string  How do I do it

User · Accepted Answer

Use DATE FORMAT    SELECT   DATE FORMAT NOW      d  m  Y   AS your date

User · Answer

This is super old  but I figured I d add my 2c  DATE FORMAT does indeed return a string  but I was looking for the CAST function  in the situation that I already had a datetime string in the database and needed to pattern match against it   http   dev mysql com doc refman 5 0 en cast-functions html  In this case  you d use   CAST date value AS char   This answers a slightly different question  but the question title seems ambiguous enough that this might help someone searching

User · Answer

Try this   concat left datefield 10  left timefield 8      10 char on date field based on full date yyyy-MM-dd  8 char on time field based on full time hh mm ss    It depends on the format you want it  normally you can use script above and you can concat another field or string as you want it   Because actually date and time field tread as string if you read it  But of course you will got error while update or insert it

[mysql] Convert datetime value into string

Examples related to mysql

Examples related to database

Examples related to string

Examples related to datetime