Which date format do you use?
- Timestamp
- YYYY-MM-DD
- DD.MM.YYYY
- Something else?

DD-MM-YYYY

Never understand how people can swap the month and day, super confusing!

YYYY-MM-DD

Display: dd-mm-YYYY
Store: YYYY-mm-dd

DD/MM/YYYY
Is this an Asia thing I just realized?

@lxmcf Americans 😰

timestamptz

For display dd-mm-yy, and the rest almost always a (long) timestamp

DD.MM.YYYY is the best

Don't care as long as it's in order.
dd-mm-yyyy or
yyyy-mm-dd is fine.

Iso 8601

*mic dropped*

Timestamp
How are you going to implement sorting in database by date with strings?

@C0D4 *Violently projectile vomits out of every possible hole in my body*

@ChrRubin yea Asian thing 😁 I also dd/mm/yyyy

YYYY-MM-DD HH-MM-SS

@rostopira afaik (at least) MySQL allows sorting by dates if you use DATE(TIME) as the datatype and format the values accordingly (YYYY-MM-DD HH:MM:SS)

YYYY-MM-DD on database so that you can easily sort it

YYYY-MM-DD but the big question is why the fuck has js no fucking proper function to format dates with whatever format I want. Every other language has got that covered by default. But noooo you have to include moment.js or datetime.js to get It... I hate js sometimes.

(D)D/(M)M/YYYY

@devJoe it's YYYY-MM-DD hh:mi:ss

mm/dd/yyyy like a normal person

@pete456 buuuh 😥

YY-MM-DD

In PHP: date('Y-m-d H:m:s')

The One True Date Format (TOTDF): YYYY-MM-DD

Shows up properly in a directory listing.

YYYY-MM-DD because sorting and because it avoids the America/Europe ordering confusion.