from mm/dd/yyyy to yyyy/mm/dd

[Asif Qureshi]

The date in my application is in mm/dd/yyyy format which i use in query
to access data from a mini system on network having data in yyyy/mm/dd
format.How can i change my date into yyyy/mm/dd format in query to get
the result.Or tell me any other solution other than changing the Date
Format of my machine.
Thanks in advance.

 

[Cor Ligthert]

Asif,

This is not really an adonet question, more for the languages newsgroups as
microsoft.public.dotnet.languages.vb and/or csharp.

What you need is this instruction. There are more overloaded formats so if
this not fit try than one of the others.

http://msdn.microsoft.com/library/d.../html/frlrfsystemdatetimeclassparsetopic1.asp

I hope this helps,

Cor

 

[Rogas69]

In SQL Server (I don't know what database you use) you can use CONVERT
function.
If you have strings in your code you can also use regex to change the order
of parts of the string.

Peter

 

[Miha Markic [MVP C#]]

Hi Asif,

You should really use parametrised queries instead.
See .net help on SqlParameter for example.

 

[Val Mazur \(MVP\)]

Hi,

To avoid any regional settings problems you suppose to use parameterized
query. In this case all the formatting issues are handled by the provider
itself and you will not worry about it. Check next example how to use
parameterized queries

http://support.microsoft.com/default.aspx?scid=kb;en-us;308049

 

[Cor Ligthert]

Miha,

You should really use parametrised queries instead.
See .net help on SqlParameter for example.
--

Where is Asif telling that he is using ADONET or even SQL. He is talking
about a MiniSystem.

I am by confused by the answers and am thinking, do I miss something, can
you help me to come out my confusion.



Cor

 

[Mythran]

Miha,


Where is Asif telling that he is using ADONET or even SQL. He is talking
about a MiniSystem.

I am by confused by the answers and am thinking, do I miss something, can
you help me to come out my confusion.



Cor

Cor,

He is posting to an adonet newsgroup and asking about queries. If the
answers are incorrect, then the question he wrote should be a little more
explained. If he can send another post explaining, I'm sure all of us can
give better answers

Mythran