How can I insert a new row by writing a query in SQL Server in my own format?

I am trying to execute a query to insert rows in to a table in SQL Server. As, its simple it is working fine and insert a row for datetime column in yyyy-MMM-dd hh:mm:ss ttt format. My problem is I have to insert the row in dd/MMM/yyyy hh:mm:ss开发者_如何学JAVA ttt format. Is it possible to do this through a query in SQL Server?

Yes, it is possible. It also is a sensless attempt. WHY do you want to introduce some culture specific date coding into your database access coding?

yyyy-MMM-dd hh:mm:ss ttt format

This is the ISO culture independant format that works regardless of what the user's computer is set to. It is there for a reason.

My Problem is i have to insert the row in dd/MMM/yyyy hh:mm:ss ttt format

No, you do not. You just are under the illusion. You ahve to insert a date time into sql server. NOTHING says you can not format it properly first.

Why do you HAVE to insert it in this particular specific format?

That should work fine, especially as the month component is MMM not MM (which can cause conversion problems).

as far as i know SQL server stores the date time in the same format internally, no matter what you give it. parsing the string to a datetime is another matter. to use different formats you can use the CONVERT function and provide the style argument, i think 113/13 is closest to what you specified