Timeline for Single data type for imprecise date values, as allowed by ISO 8601
Current License: CC BY-SA 3.0
17 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Nov 17, 2020 at 1:25 | vote | accept | bignose | ||
| May 29, 2015 at 16:04 | history | edited | Hannah Vernon♦ |
edited tags
|
|
| Sep 24, 2011 at 12:50 | comment | added | bignose | Good questions, thank you for making me think about my requirements. I'm exploring further at stackoverflow.com/questions/7539122/… | |
| Sep 24, 2011 at 12:29 | history | edited | bignose | CC BY-SA 3.0 |
correct an example
|
| Sep 24, 2011 at 10:54 | comment | added | Jack Douglas | Also, do you want A=B to imply B=A as I've assumed in my edit? | |
| Sep 24, 2011 at 10:49 | comment | added | Jack Douglas | My point is that you are stretching the definition of equality so that A=C and B=C no longer implies A=B. As long as that is what you want... see my updated answer | |
| Sep 24, 2011 at 10:42 | history | edited | bignose | CC BY-SA 3.0 |
more implications of ISO 8601
|
| Sep 24, 2011 at 10:41 | comment | added | bignose |
Not “might be”; the values are deliberately reduced-precision. The meaning of 1964-05 in ISO 8601 includes the more-precise values 1964-05-02 and 1964-05-02 18:27 and 1964-05-23. So those should all compare equal.
|
|
| Sep 24, 2011 at 10:25 | comment | added | Jack Douglas |
In other words you want the equality operator to give true when the timestamps 'might' be equal (allowing for precision)?
|
|
| Sep 24, 2011 at 10:13 | history | edited | bignose | CC BY-SA 3.0 |
more detail about expected behaviour
|
| Sep 23, 2011 at 22:36 | history | edited | bignose | CC BY-SA 3.0 |
highlight
|
| Sep 23, 2011 at 10:01 | history | tweeted | twitter.com/#!/StackDBAs/status/117176848303128576 | ||
| Sep 23, 2011 at 8:06 | history | edited | bignose | CC BY-SA 3.0 |
respond to suggestions for using different type
|
| Sep 22, 2011 at 14:15 | answer | added | Mike Sherrill 'Cat Recall' | timeline score: 6 | |
| Sep 22, 2011 at 12:49 | answer | added | Jack Douglas | timeline score: 5 | |
| Sep 22, 2011 at 1:24 | history | edited | bignose | CC BY-SA 3.0 |
fix pasted session
|
| Sep 22, 2011 at 1:01 | history | asked | bignose | CC BY-SA 3.0 |