Search
Search

Formatting MySQL long text to Date

debugcn Published at Dev
7
A. Hin

I am working with a MySQL Database where the data that I need is in a single column that is formatted as longtext. I am pulling the data out of the table with the following query. I need to format the Date column as a Date Colum in the following format mm-dd-yy so that the front end Database utility can filter by date or date range.

SELECT entry_id,

GROUP_CONCAT(IF(field_id='fld_5076430', value,'') SEPARATOR '') AS user,

GROUP_CONCAT(IF(field_id='fld_8768091', value,'') SEPARATOR '') AS first,

GROUP_CONCAT(IF(field_id='fld_9970286', value,'') SEPARATOR '') AS last,

GROUP_CONCAT(IF(field_id='fld_6009157', value,'') SEPARATOR '') AS date,

GROUP_CONCAT(IF(field_id='fld_5105414', value,'') SEPARATOR '') AS event,

GROUP_CONCAT(IF(field_id='fld_7723931', value,'') SEPARATOR '') AS unit,

GROUP_CONCAT(IF(field_id='fld_1521970', value,'') SEPARATOR '') AS work,

GROUP_CONCAT(IF(field_id='fld_4590434', value,'') SEPARATOR '') AS hours

FROM kcdte_cf_form_entry_values

GROUP BY entry_id;

Thank you for your help.

ecp

Without more information, you could simply use:

STR_TO_DATE("string", "%M %d %Y")

Collected from the Internet

Please contact [email protected] to delete if infringement.

edited at
0

Comments

0 comments
Login to comment

Related

From Dev

formatting string date into mysql date

From Dev

MySQL/PHP - text formatting

From Dev

Extracting and formatting date string to MySQL

From Dev

Application of date formatting on x-axis text

From Dev

PHP Date Formatting from MySQL Fatched Datetime

From Dev

Convert MySQL Date to long format date

From Dev

Date formatting

From Dev

Formatting text

From Dev

Current datetime in Joda-Time date formatting for mysql timestamp

From Dev

LilyPond: formatting long footnotes

From Dev

Formatting long pattern matching

From Dev

Pretty formatting of long string

From Dev

Disable date-formatting for domain axis in JFreeChart when x-data is Long

From Dev

Disable date-formatting for domain axis in JFreeChart when x-data is Long

From Dev

XML parse with PHP / MySQL database Statements and import within mysql arabic letters date formatting

From Dev

XML parse with PHP / MySQL database Statements and import within mysql arabic letters date formatting

From Dev

Mysql GROUP BY DATE from text column

From Dev

Building a text string from date details in MySQL

From Dev

Convert text column in date mysql issue

From Dev

Convert Date Formatting Codes to date

From Dev

getline, awk and date (formatting date)

From Dev

getline, awk and date (formatting date)

From Dev

Formula losing date formatting

From Dev

Date formatting JSON

From Dev

Formatting date javascript

From Dev

Java Date Formatting ParseException

From Java

Rails formatting date

From Dev

django template date formatting

From Dev

Date Formatting is not working in android?

Related Related

  1. 1

    formatting string date into mysql date

  2. 2

    MySQL/PHP - text formatting

  3. 3

    Extracting and formatting date string to MySQL

  4. 4

    Application of date formatting on x-axis text

  5. 5

    PHP Date Formatting from MySQL Fatched Datetime

  6. 6

    Convert MySQL Date to long format date

  7. 7

    Date formatting

  8. 8

    Formatting text

  9. 9

    Current datetime in Joda-Time date formatting for mysql timestamp

  10. 10

    LilyPond: formatting long footnotes

  11. 11

    Formatting long pattern matching

  12. 12

    Pretty formatting of long string

  13. 13

    Disable date-formatting for domain axis in JFreeChart when x-data is Long

  14. 14

    Disable date-formatting for domain axis in JFreeChart when x-data is Long

  15. 15

    XML parse with PHP / MySQL database Statements and import within mysql arabic letters date formatting

  16. 16

    XML parse with PHP / MySQL database Statements and import within mysql arabic letters date formatting

  17. 17

    Mysql GROUP BY DATE from text column

  18. 18

    Building a text string from date details in MySQL

  19. 19

    Convert text column in date mysql issue

  20. 20

    Convert Date Formatting Codes to date

  21. 21

    getline, awk and date (formatting date)

  22. 22

    getline, awk and date (formatting date)

  23. 23

    Formula losing date formatting

  24. 24

    Date formatting JSON

  25. 25

    Formatting date javascript

  26. 26

    Java Date Formatting ParseException

  27. 27

    Rails formatting date

  28. 28

    django template date formatting

  29. 29

    Date Formatting is not working in android?

HotTag

Archive