Skip to Content
0
Former Member
Feb 26, 2009 at 12:36 PM

date format issue

28 Views

i have defined a vriable CREATED_TIME(

DATA CREATED_TIME(14) type c.

and i have another variable

xdate which is of the format (YYYYMMDDhhmmssmmmuuun)

i want to fetch first 14 chars in the created_time variable

i have written

CREATED_TIME = xdate.

the data which is coming

xdate =20080923050145.1600000

CREATED_TIME = *50145.1600000

where as in created_time i want 20080923050145. how to do that