DateTime

[Tom]

Hi

There is a datetime type with length 8 in a table

I tried to insert the Local System datetime to it from aspx.cs file. But, the outcome are

string sysdatetime = System.DateTime.Now.ToShortDateString(); //output 1900-01-01 00:00:00.000 in tabl
string sysdatetime = System.DateTime.Now.ToLongDateString(); //output 1900-01-01 00:00:00.000 in tabl
DateTime sysdatetime = System.DateTime.Now; //Compile error. Cannot convert char to datetim

They cannot output today datetime. How should I fix it

And, how can I get only Date 1900-01-01, only Time 00:00:00 or both DateTime 1900-01-01 00:00:00

Thanks

[José Joye]

play with "custom DateTime Format Strings" (refer to MSDN for complete
description)

in your case:
DateTime.Now.ToString("yyy-MM-dd");
DateTime.Now.ToString("hh:mm:ss");

José

"Tom" <ke*****@yahoo.com> wrote in message
news:AD**********************************@microsof t.com...

Hi,

There is a datetime type with length 8 in a table.

I tried to insert the Local System datetime to it from aspx.cs file. But, the outcome are:
string sysdatetime = System.DateTime.Now.ToShortDateString(); //output 1900-01-01 00:00:00.000 in table string sysdatetime = System.DateTime.Now.ToLongDateString(); //output 1900-01-01 00:00:00.000 in table DateTime sysdatetime = System.DateTime.Now; //Compile error. Cannot convert char to datetime
They cannot output today datetime. How should I fix it?

And, how can I get only Date 1900-01-01, only Time 00:00:00 or both DateTime 1900-01-01 00:00:00?
Thanks

[Tom]

Hi

I use the following syntax

System.DateTime.Now.ToString("yyy-MM-dd hh:mm:ss")

The data in table changes from 1900-01-01 00:00:00.000 to 1/1/1900

It cannot retrieve the current datetime of the OS.

[José Joye]

I'm not too sure what you are trying to do...
However, I made a mistake, it should be
System.DateTime.Now.ToString("yyyy-MM-dd hh:mm:ss");

As I see it you store your info inside a dB. Do you use a store procedure to
do it?
Assuming yes and that you use a dateTime as sql type, you could do the
following:
...
// Get a command object and make it part of transaction if needed
SqlCommand SqlCmd = new SqlCommand("UpdateCredentialsForTarget",
m_dBConnect, m_dBTrans);

SqlCmd.CommandType = CommandType.StoredProcedure;
SqlCmd.Parameters.Add("@myDate", SqlDbType.DateTime).Value = DateTime.Now;
// Execute the SP
SqlCmd.ExecuteNonQuery();

José

"Tom" <ke*****@yahoo.com> wrote in message
news:E7**********************************@microsof t.com...

Hi,

I use the following syntax:

System.DateTime.Now.ToString("yyy-MM-dd hh:mm:ss");

The data in table changes from 1900-01-01 00:00:00.000 to 1/1/1900

It cannot retrieve the current datetime of the OS.

[Jon Skeet [C# MVP]]

Tom <ke*****@yahoo.com> wrote:

I use the following syntax:

System.DateTime.Now.ToString("yyy-MM-dd hh:mm:ss");

The data in table changes from 1900-01-01 00:00:00.000 to 1/1/1900

It cannot retrieve the current datetime of the OS.

When you say "table", what exactly is your context? Is it a DataTable?
If so, you should make the type of your column a DateTime rather than
String.

--
Jon Skeet - <sk***@pobox.com>
http://www.pobox.com/~skeet
If replying to the group, please do not mail me too

[Tom]

The table schema

userid int
registerdate datetime

The cs clas

protected System.DateTime CurDateTime
CurDateTime = System.DateTime.Now

The SQL i

INSERT INTO tablename (registerdate) values (this.CurDateTime); //it returns erro

I did not use stored procedure

How should I fix it

[Tom]

I tried CurDateTime.ToString();

It insert 1/1/1900 as DateTime

Why not current date and time?

[Tom]

Sorry, I missed that I am using MS SQL 2000

[Austin Ehlers]

My guess is that that date is the default datetime when an invalid
datetime format is passed. Look in the SQL docs for how the string
needs to be formatted, and then call the ToString("...") with the
proper format.

Austin Ehlers

On Thu, 26 Feb 2004 09:36:11 -0800, Tom <ke*****@yahoo.com> wrote:

I tried CurDateTime.ToString();

It insert 1/1/1900 as DateTime.

Why not current date and time?

[Jon Skeet [C# MVP]]

Tom <ke*****@yahoo.com> wrote:

The table schema:

userid int 4
registerdate datetime 8

The cs class

protected System.DateTime CurDateTime;
CurDateTime = System.DateTime.Now;

The SQL is

INSERT INTO tablename (registerdate) values (this.CurDateTime); //it
returns error

I did not use stored procedure.

How should I fix it?

You should use a parameter in your command instead, and then set the
value of the parameter to the DateTime value you want. That way the
drivers deal with all the conversions for you.

--
Jon Skeet - <sk***@pobox.com>
http://www.pobox.com/~skeet
If replying to the group, please do not mail me too