SUBSTR & TIMESTAMP

[rani80]

Is it possible just to update the date in the timestap field?

SELECT SUBSTR(TIMESTAMP,1,8)
FROM TABLE

That does not work.

 

[mrdenny]

This will work assuming that the TimeStamp column is DateTime or SmallDateTime.

select convert(varchar(10), TimeStamp, 101)
from TAble

Denny
MCSA (2003) / MCDBA (SQL 2000)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

Donate to Katrina relief

 

[rani80]

Doesn't seem to be working for me...

SQLCODE = -104, ERROR: ILLEGAL SYMBOL "CONVERT". SOME SYMBOLS THAT
MIGHT BE LEGAL ARE: + -
SQLSTATE = 42601 SQLSTATE RETURN CODE

 

[jbenson001]

Read mrdenny's original post. CONVERT will only work on a datetime or smalldatetime. If the column is a timestamp it will not work.

 

[vongrunt]

** sniff sniff **

DB2?

------
"There's a man... He's bald and wears a short-sleeved shirt, and somehow he's very important to me. I think his name is Homer."
(Jack O'Neill, Stargate)

 

[mrdenny]

That's a good question. What RDBMS are you using?

Denny
MCSA (2003) / MCDBA (SQL 2000)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

Donate to Katrina relief

 

[SQLBill]

To borrow vongrunt's comment:

**sniff sniff**

Could you be posting an ORACLE question in the Microsoft SQL Server forum???

-SQLBill

Posting advice: FAQ481-4875