Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
preethi_rjs
Starting Member
1 Post |
 Posted - 2007-01-19 : 20:43:17
|
hi i am new to MS SQL.Front end:VB.in the text box ill b getting Date in DD/MM/YYYY format.while saving in the backend, can i have date alone(without time) and of the format DD/MM/YYYY.so that while retrieving i can compare between dates.plz help me!  |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2007-01-19 : 22:23:26
|
make sure that your table column's data type should be in datetime and not varchar or char.while retrieving (select) from your table, just use select datecol from yourtable it will return the date in datetime. If you want to format it in DD/MM/YYYY, you should do it in your VB front end. You can also do it in SQL (using convert() function) but it is not advisable.Take a look at this thread http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=76862
KH |
 |
|
|
|
|
|
Date