Timeline for What is the best smallest data type size for 19 digit number?
Current License: CC BY-SA 4.0
18 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Aug 16, 2018 at 18:43 | comment | added | Nano | Thanks all, In fact I am using sync framework that did not allow me to use "auto-increment". that the reason way I have to make it remotely. in the end I will choice BIGINT because that will let me use less conversion. | |
| Aug 16, 2018 at 17:53 | vote | accept | Nano | ||
| Aug 16, 2018 at 9:55 | answer | added | Phill W. | timeline score: 4 | |
| Aug 16, 2018 at 8:33 | comment | added | Colin 't Hart | @mustaccio I don't agree. Never store dates as string. What people are going to do with the data later always changes, and you just know someone is going to want to do date arithmetic on it in future. So just use a date/time datatype from the get go. | |
| Aug 16, 2018 at 8:28 | comment | added | Colin 't Hart | Please don't store dates and times as strings. Do the conversion in your presentation layer. | |
| Aug 16, 2018 at 7:12 | history | edited | Paul White♦ | CC BY-SA 4.0 |
edited tags
|
| Aug 16, 2018 at 6:55 | answer | added | motoDrizzt | timeline score: 5 | |
| S Aug 16, 2018 at 5:51 | history | edited | John K. N. | CC BY-SA 4.0 |
Formatted content; enhanced grammar; fixed typographical errors; removed spacing where not required;
|
| S Aug 16, 2018 at 5:51 | history | suggested | Chaminda Bandara | CC BY-SA 4.0 |
Format content
|
| Aug 16, 2018 at 5:06 | review | Suggested edits | |||
| S Aug 16, 2018 at 5:51 | |||||
| Aug 16, 2018 at 4:34 | comment | added | Akina | You have data in TIMESTAMP(5) format, and no reason to store it in different format. | |
| Aug 16, 2018 at 3:15 | review | Close votes | |||
| Aug 16, 2018 at 16:25 | |||||
| Aug 16, 2018 at 2:55 | comment | added | mustaccio | The answer totally depends on what you're planning to do with that value later. | |
| Aug 16, 2018 at 1:31 | history | undeleted | Nano | ||
| Aug 16, 2018 at 1:29 | history | deleted | Nano | via Vote | |
| Aug 16, 2018 at 0:54 | history | edited | Nano | CC BY-SA 4.0 |
edited title
|
| Aug 16, 2018 at 0:45 | review | First posts | |||
| Aug 16, 2018 at 1:30 | |||||
| Aug 16, 2018 at 0:43 | history | asked | Nano | CC BY-SA 4.0 |