- Feature Articles
-
CodeSOD
- Most Recent Articles
- A Sudden Tern
- Going Through Time
- A Pirate's Confession
- The Review
- No Yes
- The Utils
- A Case of Old Code
- Linguistic Perls
-
Error'd
- Most Recent Articles
- Chicken Feed
- Twofers
- Two-faced
- Boxing Day Math
- Michael's Holiday Snaps
- Anonymice
- A Horse With No Name
- On the Dark Side
-
Forums
-
Other Articles
- Random Article
- Other Series
- Alex's Soapbox
- Announcements
- Best of…
- Best of Email
- Best of the Sidebar
- Bring Your Own Code
- Coded Smorgasbord
- Mandatory Fun Day
- Off Topic
- Representative Line
- News Roundup
- Editor's Soapbox
- Software on the Rocks
- Souvenir Potpourri
- Sponsor Post
- Tales from the Interview
- The Daily WTF: Live
- Virtudyne
Admin
Let's see.... In the drone headline, they apparently didn't know about dotless "ı", while in the subheading, they knew about it, but couldn't manage to display it. Impressive!
Admin
Ngeative frist!
Admin
ordinal (937-305-0631)
And I give Barry props for the twin swap.
Admin
huh
Admin
For a while I worked moving data from MS-SQL to MySQL. The only format they shared in common at the time was .csv. We would manually inspect the files using Excel. All of the datetimes were treated as formulas no matter what we did. So "2002-06-15T13:05:45Z" would show up as -1981T13:05:45Z. I hear it’s better about it these days, but thank you OpenOffice
Admin
I want to share my experience to help others avoid the same mistake. In August, I fell victim to an online scam [ed: more spam that must have snuck by our filters. This remains here for context. ]
Admin
Hooray for stinking spam. Thank goodness the capthca stops all that [/s]
Admin
Why not go a bit further and treat ":" either as division ("/") or relation (as in "a : b = c : d"), and use "T" and "Z" as a variable to solve? The intermediate result -1981T13:05:45Z could then be calculated either as -1981 / 13 / 05 / 45, or as an relational equation -1981 * T * 13 : 05 = 1 : 45 * Z (multiplication implied, factor 1 assumed), populating cells T1 and Z1 with the results for T and Z, or nonsense if there aren't any. All those expensive spreadsheet calculation programs with their formula engines could now prove useful!