Convert varchar string into Date format Query Laravel

Question

I'm having a trouble on how can I convert my filename into date time format. The format of my filename is varchar and The problem is the last part of the name file is not formatted as a date it should be formatted in hour, minutes and AM/PM see my sample image below. do you have any idea of this ? change from 33250400 to 01-47 PM. It would be great if anybody could figure out, thank you so much in advance!.

Expected output

2021-03-30-01-47 PM.csv

sample-Image

What I've tried

 ->select(['table.*',DB::raw(' DATE_FORMAT(table.file_name, "%Y-%m-%d-%h:%i %p") AS final_date')

Shailendra · Accepted Answer · 2021-03-30 10:25:15Z

1

You are passing filename to DATE_FORMAT function which contains .csv extension that is why you are not getting your expected output but if you still want date time format of filename then you can select records from database and you can remove .csv extension from each filename record string and then use date function to get your desired output

answered Mar 30, 2021 at 10:25

Shailendra

4011 gold badge11 silver badges19 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Henry Over a year ago

Thanks for your response, I've been mistaken from my question. I just want to get the value to those I've been marked red in the image into hour and minutes and then the format of the file like .csv

Henry Over a year ago

The output should look like this 2021-03-30-01-47 PM.csv do you have idea of this ? from 33250400 to 01-47 PM.

Collectives™ on Stack Overflow

Convert varchar string into Date format Query Laravel

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related