Convert data

Question

0.00/5 (No votes)

See more:

Is "current_timestamp" command working for sql server 2005.

ALTER TABLE item_location ALTER COLUMN date current_timestamp;

is there z any problem n above query. if so how can i correct it :)

Posted 4-Jun-10 21:53pm

Strider87

Updated 4-Jun-10 21:57pm

v3

Add a Solution

1 solution

Add a Solution

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

Sandeep Mewara · Accepted Answer · 2010-06-04T22:31:00

Solution 1

Strider87 wrote:
Is "current_timestamp" command working for sql server 2005

Yes. Look here: http://msdn.microsoft.com/en-us/library/ms188751.aspx[^]

Strider87 wrote:
there z any problem n above query

Look here:
http://msdn.microsoft.com/en-us/library/aa275462(v=SQL.80).aspx[^]

Posted 4-Jun-10 22:31pm

Sandeep Mewara

Comments

Strider87 5-Jun-10 4:09am

thanx sandeep

Convert data

1 solution

Solution 1

Add your solution here

Preview 0

Convert data

1 solution

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us