How to solve Date Time Conversion

Question

0.00/5 (No votes)

See more:

Dear Friends,

I have a datetime (dd/MM/yyyy Format) conversion error when i save values, retrieve, search values. i gave MM/dd/yyyy Format Its take before 12 days dd/MM/yyyy Format after 12 takes MM/dd/yyyy format.

Its a big problem to retrieve a report.. how to solve this problem..

Thanks & Regards,
Vivek .R

Posted 22-Nov-15 18:33pm

Vivek.anand34

Add a Solution

Comments

Arasappan 23-Nov-15 0:36am

the format u saved in sql is

Jawad Ahmed Tanoli 23-Nov-15 0:41am

can you share your error during conversion and code

Vivek.anand34 23-Nov-15 2:09am

in database its saved yyyy-mm-dd with time format...

1 solution

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Suvendu Shekhar Giri · Answer 1 · 2015-11-22T19:03:00

Solution 1

Use ``yyyy-MM-dd`` format then.
It has no variant and should work always.
Also check following-
Using the InvariantCulture Property[^]

Thanks :)

Posted 22-Nov-15 19:03pm

Suvendu Shekhar Giri

Comments

Vivek.anand34 23-Nov-15 2:22am

yyyy-MM-dd is not good for client.. thats why am trying dd/MM/yyyy format... I will InvariantCulture Property above link...

Vivek.anand34 23-Nov-15 4:14am

Actually its My Mistake I converted the datetime to date its a problem. I solved it.. acutally in db i put datetime format. and Textbox (MM/dd/yyyy) format. It executes now...

Suvendu Shekhar Giri 23-Nov-15 4:36am

Still it should work. You can store a date value in datetime field.
Anyway, great that it is solved.

Vivek.anand34 23-Nov-15 4:14am

Thanks For Help

How to solve Date Time Conversion

1 solution

Solution 1

Add your solution here

Preview 0

How to solve Date Time Conversion

1 solution

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us