is convert function bidirectional 1

[tektipdjango]

it's unclear for me if convert function is used from datetime to string only or also the opposite way.
Can anyone help me
Thank's inadvance

--------------------------------------------------
[highlight]Django[/highlight]
bug exterminator
tips'n tricks addict​

 

[SQLBill]

It can go either way.

SELECT CONVERT(DATETIME, '4/2/2004'),
       CONVERT(VARCHAR(20), GETDATE, 121)

-SQLBill

 

[SQLBill]

Forgot to add that it can also be used for other conversions...

DECLARE @var1 CHAR(2)
SET @var1 = '12'
DECLARE @var2 INT
SET @var2 = 34
SELECT CONVERT(INT, @var1),
       CONVERT(DECIMAL(3,1), @var1),
       CONVERT(CHAR(2), @var2)

-SQLBill