473,324 Members | 2,511 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,324 software developers and data experts.

DateTime sql server - sqldataadapter

Hi,

I have a DateTime in one of my table in sql serveur. The format of the
datetime is yyyy-mm-dd. I have an sqladapter in my application
connected with this table and when the format of the date is not
yyyy-mm-dd (on the local computer where my application is running), I
have some problem with the insert/upgrade. My question is: How can I
change the value in the sqldataadapter just before the update?
(because all I display is the hour or the date and the yyyy-mm-dd are
fixed) so I try via the dataset but it doesnt work.
Thanks
Jul 21 '05 #1
2 1623
Eric,

The format of the datetime in a SQLserver are ticks accoording to a certain
start time (which I always forget).

When presentated are those translated accoording settings of the
computer/database or the code that is used in the program. (See for that the
overloaded function of ToString() for datetimes. Be so clever to use the
short notations (by instance "d") and not the very hardcoded ones as
"dd:MM:yyyy")

I hope this helps?

Cor
Jul 21 '05 #2
"Cor Ligthert" <no************@planet.nl> wrote in message news:<#x**************@TK2MSFTNGP10.phx.gbl>...
Eric,

The format of the datetime in a SQLserver are ticks accoording to a certain
start time (which I always forget).

When presentated are those translated accoording settings of the
computer/database or the code that is used in the program. (See for that the
overloaded function of ToString() for datetimes. Be so clever to use the
short notations (by instance "d") and not the very hardcoded ones as
"dd:MM:yyyy")

I hope this helps?

Cor


Yes, thank you.
Jul 21 '05 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
by: Iwan Petrow | last post by:
Hi, I have a column DateTime in a table in MS SQL Server database. I take this column using a Web Service and show it in a TextBox in a Web Application. I want the format of the date to be...
5
by: I am Sam | last post by:
I have created this DateTime object and instanced it I think correctly DateTime myClubNow1=new...
2
by: Eric | last post by:
Hi, I have a DateTime in one of my table in sql serveur. The format of the datetime is yyyy-mm-dd. I have an sqladapter in my application connected with this table and when the format of the...
5
by: Mike | last post by:
Hi, I use MS SQL Express and VS 2005 c#, win application. I would like to select value rom DateTimePicker and list all values for selected date within GridView. I have method as follows: ...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.