all groups > sql server programming > september 2005 >
You're in the

sql server programming

group:

datetime in XP


datetime in XP ricva
9/21/2005 10:17:02 PM
sql server programming:
I am passing in a datetime value into a extended stored procedure, and
thought I could read it into a double. its failing and I am not sure
why.

...

BYTE bType;
ULONG ulMaxLen;
ULONG ulActualLen;
BOOL isParamNull;

int inputParamIndex = 1;
srv_paraminfo(srvroc, inputParamIndex, &bType, &ulMaxLen,
&ulActualLen, NULL, &isParamNull );
BYTE* ldata = new BYTE[ulActualLen];
memset(ldata, '\0', ulActualLen);
srv_paraminfo(Proc, inputParamIndex, &bType, &ulMaxLen, &ulActualLen,
ldata, &isParamNull );
double xdate = (double)*ldata;
delete []ldata;
....


xdate should have the date, but doesn't.

Thanks
Re: datetime in XP ricva
9/23/2005 10:01:44 AM
I figured it out
AddThis Social Bookmark Button