what is the pattern of datetime in sql?

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.

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

resolved

Please Mark as Solved.

Peace.

In general in sql data time s stored mm/dd/yyyy..
you want (dd//mm/yyyy you) like this type of date format ?

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.