...I want convert the date time to char, but faild...

below is test code:

DBDATETIME : 2009-06-02 00:00:00.000

  

TABLE FILE SQLOUT
PRINT
COMPUTE TEST1/HYYMDm = DBDATETIME;

-*COMPUTE TEST2/A100 =TEST1;

how can I write the TEST2 ? i want print the char date wiht html loyout.

Thanks,
James

This message has been edited. Last edited by: Yangyang,

Please check the H functions, ther is one for converting a datetime to text, it has been mentioned in the forum before.

You should get yourself a copy of the Functions manual it is free to download, use the documentation link above.

thanks Waz,

I searched , but i didn't fount yet...

i try a lot of ways... but it's not work well..


this way can fix this issue:

  

COMPUTE TEST1/HYYMDm = date;NOPRINT
COMPUTE test2/A50 =HCNVRT(TEST1, '(HYYMDS)', 20, 'A20'); NOPRINT

Thanks,
James

This message has been edited. Last edited by: Yangyang,

James,

Check out the HCNVRT function.

T