Click here to Skip to main content
12,352,294 members (55,344 online)
Rate this:
 
Please Sign up or sign in to vote.
See more: SQL-Server
I m having problem in storing date in sql server 2008 express, i m storing date of birth in MM-DD-YYYY formate. But when i m retriving it from the server it does not works properly. The datatype is date.
Posted 13-Feb-13 8:07am
Comments
Maciej Los 13-Feb-13 14:12pm
   
What it means "it does not works properly"???
Niraj Andharia 1-Sep-14 0:51am
   
Thank you..
Niraj Andharia 1-Sep-14 0:52am
   
it means when I retrieve date it is in a different formate
Rate this: bad
 
good
Please Sign up or sign in to vote.

Solution 1

I believe SET DATEFORMAT[^] would help you.
  Permalink  
Comments
Niraj Andharia 1-Sep-14 0:52am
   
Thank you..
Rate this: bad
 
good
Please Sign up or sign in to vote.

Solution 2

  Permalink  
Comments
Niraj Andharia 1-Sep-14 0:51am
   
Thank you..

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

  Print Answers RSS
Top Experts
Last 24hrsThis month


Advertise | Privacy | Mobile
Web02 | 2.8.160621.1 | Last Updated 25 Feb 2013
Copyright © CodeProject, 1999-2016
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100