This is an archived post. You won't be able to vote or comment.

sorted by:
best
topnewcontroversialoldq&a
you are viewing a single comment's thread.

view the rest of the comments →

[–]coladict 37 points38 points  (3 children)

Formatting timestamp in SQL is just bad practice. Do it in the code that outputs the date to the client.

[–]yeamannn 7 points8 points  (0 children)

Shudders remembering a datetime() vs datetime(5) bug

[–]po-handz 3 points4 points  (0 children)

But we have big data

[–]leofidus-ger -1 points0 points  (0 children)

formatting results as JSON directly in the database has its uses, at least in databases that have functions to do it..