what is the pattern of datetime in sql?
xanawa -3 Junior Poster
Recommended Answers
Jump to PostI think you are asking about the Raw DateTime format as you receive from it from the Database.
This varies on the database itself.
MSSQL spits it out like this: yyyyMMdd HH:mm:sss:hhh
MySQL I believe is yyyyMMddHHmmss
If you mean how to you Enter Date into …
Jump to PostCheck it out here: http://www.sqlusa.com/bestpractices2005/centurydateformat/
Its all written.
All 6 Replies
finito 46 Nearly a Posting Virtuoso
I think you are asking about the Raw DateTime format as you receive from it from the Database.
This varies on the database itself.
MSSQL spits it out like this: yyyyMMdd HH:mm:sss:hhh
MySQL I believe is yyyyMMddHHmmss
If you mean how to you Enter Date into a DateTime variable
Then you need to use ParseExact.
Peace.
Mitja Bonca 557 Nearly a Posting Maven
xanawa -3 Junior Poster
I think you are asking about the Raw DateTime format as you receive from it from the Database.
This varies on the database itself.
MSSQL spits it out like this: yyyyMMdd HH:mm:sss:hhh
MySQL I believe is yyyyMMddHHmmss
If you mean how to you Enter Date into a DateTime variable
Then you need to use ParseExact.
Peace.
resolved
finito 46 Nearly a Posting Virtuoso
resolved
Please Mark as Solved.
Peace.
tbanisida 0 Newbie Poster
In general in sql data time s stored mm/dd/yyyy..
you want (dd//mm/yyyy you) like this type of date format ?
xanawa -3 Junior Poster
In general in sql data time s stored mm/dd/yyyy..
you want (dd//mm/yyyy you) like this type of date format ?
no it's ok i found the pattern
MM/dd/yyyy HH:mm:ss
thx :)
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.