Questions tagged [str-to-date]
139 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
…
Dumitru Dumitrel
- 3
- 3
-3
votes
1 answer
Format date in PHP MMddyyyyHHmmss to m-d-y
Date Format using PHP
Input date is '1568145593000', i need to convert into m-d-y format using php
Anyone knows how to convert this? Thanks =).
Vincy Joseph
- 223
- 1
- 3
- 15
-4
votes
2 answers
ORDER BY STR_TO_DATE ASC not functioning as expected
Heres my select query,
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) from r_post_getyou where…
zheus walker
- 1
- 3
-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
Reza
- 85
- 1
- 3
- 10