Questions tagged [str-to-date]
123 questions
-2
votes
1 answer
How to convert a string to date in Mysql ? I try to use str_to_date but I did not succeed
I have a table C
create table C (A varchar(100), B varchar (100));
In columns A and B I have this information:
A B
22/04/2005 01:52:34
05/12/2005 04:16:02
07/11/2004 11:24:27
07/05/2008 06:35:44
…
![](../../users/profiles/6823657.webp)
Dumitru Dumitrel
- 3
- 3
-3
votes
2 answers
ORDER BY ASC NOT WORKING MYSQL DATETIME STR_TO_DATE
Heres my select query, enter image description here
select rac_username, rac_profilepicture, tafd_postid, tafd_postcontent, tafd_postimage_source, DATE_FORMAT(tafd_postadded,'%M %d, %Y') tafd_postadded,tafd_imotion, (select count(rpg_actormakeget)…
![](../../users/profiles/10768968.webp)
zheus walker
- 1
- 2
-4
votes
3 answers
Convert this query to eloquent
I'm a noob in Laravel. can anyone help me write this query in eloquent
SELECT
*
FROM
table
WHERE
(
STR_TO_DATE(`date`, '%m/%d/%Y') BETWEEN '2014-08-05'
AND '2014-08-05'
)
ORDER BY
id
![](../../users/profiles/863354.webp)
Reza
- 85
- 1
- 2
- 10