sql dateTime

[xanawa]

what is the pattern of datetime in sql?

[finito]

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]

Check it out here: http://www.sqlusa.com/bestpractices2005/centurydateformat/
Its all written.

[xanawa]

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]

resolved

Please Mark as Solved.

Peace.

[tbanisida]

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

[xanawa]

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 :)