Timeline for Need to convert date to word using trigger
Current License: CC BY-SA 3.0
13 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Feb 8, 2015 at 6:36 | vote | accept | Acube | ||
| Feb 8, 2015 at 5:28 | answer | added | RolandoMySQLDBA | timeline score: 1 | |
| Feb 8, 2015 at 5:02 | comment | added | Acube | @ RolandoMySQLDBA : yes the database is mcet, the output screenshot of SELECT date_to_words(NOW()); is posted above. | |
| Feb 8, 2015 at 4:59 | history | edited | Acube | CC BY-SA 3.0 |
added 111 characters in body
|
| Feb 7, 2015 at 20:58 | comment | added | RolandoMySQLDBA |
Next question: Is the table for this trigger in the mcet database ?
|
|
| Feb 7, 2015 at 20:53 | comment | added | RolandoMySQLDBA |
Here is a question: What exactly would the output of the date_to_words function produce ? For example, what would be the output of SELECT date_to_words(NOW()); ?
|
|
| Feb 7, 2015 at 6:59 | history | edited | Acube | CC BY-SA 3.0 |
added 135 characters in body
|
| Feb 7, 2015 at 6:35 | comment | added | Acube | cant post the full function, too long to post the output of the SHOW CREATE FUNCTION date_to_words\G | |
| Feb 7, 2015 at 5:00 | comment | added | Acube | i need for my application the date field in date and in word format for printing in reports | |
| Feb 6, 2015 at 19:14 | comment | added | Vérace | As a matter of interest, why did you do this? DATEs should be stored as DATEs, VARCHARs as VARCHARS and so on. | |
| Feb 6, 2015 at 19:04 | comment | added | RolandoMySQLDBA |
Please run SHOW CREATE FUNCTION date_to_words\G and post the output.
|
|
| Feb 6, 2015 at 17:47 | answer | added | Rick James | timeline score: 0 | |
| Feb 6, 2015 at 9:06 | history | asked | Acube | CC BY-SA 3.0 |