Forum Date Format

Question

Forum Date Format

Michael Valentine Jones

SSC Guru

Points: 64818
More actions
March 17, 2007 at 12:24 pm

#61885

I noticed that the forum date format is DD/MM/YYYY (15/03/2007 05:26:00).
Is this a recent change or maybe a mistake?
If you want to go with an international date format, why not use the ISO format, YYYY-MM-DD HH:MM:SS?

Viewing 15 posts - 1 through 15 (of 24 total)

You must be logged in to reply to this topic. Login to reply

K. Brian Kelley SSC Guru Points: 114642 More actions · Answer 1

It used to be the other way, the way the US uses it. I wonder if the switch-over is due to moving servers from the US to UK?

K. Brian Kelley
@kbriankelley

K. Brian Kelley SSC Guru Points: 114642 More actions · Answer 2

As a followup, looks like Steve and crew are aware of the issue:

http://blogs.sqlservercentral.com/blogs/steve_jones/archive/2007/03/17/1474.aspx

K. Brian Kelley
@kbriankelley

Steve Jones - SSC Editor SSC Guru Points: 736255 More actions · Answer 3

We're digging in. It has to be something with the forum software. All the other dates in ASP and on other sites are working in US format. Servers are set to US format, MST, but not working for some reason.

We'll be on it first thing Mon am with the vendor.

PhilM99 SSCrazy Points: 2214 More actions · Answer 4

FWIW, those of us in the ROW (rest of the World) would like to see something other than the US format. For dates in the first twelve days of every month, we have to guess what date is meant. Only the International (yyyy-mm-dd) is self-describing and explicit. So it would be cool if you would use it. Even the ROW format dd-mm-yyyy leaves you guessing.

The International format also sorts properly even when in character format!!

(Canadian Lurker)

Rudyx - the Doctor SSC-Forever Points: 43695 More actions · Answer 5

Interesting. I did no even notice the dates seeing as I am more intrested in the content. Not being a web operson in any way shape or form ... is there not a way to have it displayed on the web pages based on the individual computer's defalt date settings ? I'm sure that this would satisfy everyone. After all behind the scenes in the database the storage is just plain ole 'datetime' ...

RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."

Michael T SSC-Addicted Points: 479 More actions · Answer 6

I admit to being confused for first 12 days of each month with the US and ROW formats, so make that 2 votes from Canada for the Internalional format (yyyy-mm-dd), eh!

Besides: it's easiest to ramp up my memory with what changes least often, the year, and work up to those pesky days.

SQLBill SSC Guru Points: 51440 More actions · Answer 7

This is a SQL Server site....so the DATE TIME format should be YYYYMMDD HH:SS:MM.

At least that's my 2 cents.

-SQLBill

K. Brian Kelley SSC Guru Points: 114642 More actions · Answer 8

K. Brian Kelley

SSC Guru

Points: 114642

March 20, 2007 at 1:56 pm

#696035

Stardate, anyone?

K. Brian Kelley
@kbriankelley

Sarah Dutkiewicz SSCommitted Points: 1870 More actions · Answer 9

If you want to follow the ISO8601 standard, then it's:

YYYY-MM-DD HH:MM:SS

(Might want to flip your minutes and seconds around there, SQLBill )

SQLBill SSC Guru Points: 51440 More actions · Answer 10

ARGH! I needed sleep that day - or maybe I WAS asleep.

-SQLBill

Rudyx - the Doctor SSC-Forever Points: 43695 More actions · Answer 11

non ECC RAM ... hmmm ... parity hits ... hmmm ...

penny-wise and pound foolish

RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."

Mohamed Saleh-392080 Grasshopper Points: 23 More actions · Answer 12

Greetings to all you great members,

Speaking about date format, I am in a little problem. I made a dataset and I want to use a query that gives this meaning:

Select * from (TableName) where birthdate = Nothing

I mean the Birthdate column is empty. Which expression replaces the word "Nothing" here.

Thanks in advance.

K. Brian Kelley SSC Guru Points: 114642 More actions · Answer 13

SELECT * FROM (TableName) WHERE birthdate IS NULL

K. Brian Kelley
@kbriankelley

Mohamed Saleh-392080 Grasshopper Points: 23 More actions · Answer 14

Before anything, I want to express my thanks for your quick answer.

I appreciate your help it is of great value to me.

Again thank you very much.