Mssql Log file shows that the date was changed, Flex to Coldfusion

[nikos101]

If I pass a Flex date object with its to String outputing:

Thu Mar 26 23:59:59 GMT+0000 2009

private function getBranchData():void
{
var toDateMod:Date=to_date.selectedDate;
toDateMod.hours=23;
toDateMod.minutes=59;
toDateMod.seconds=59;
toDateMod.milliseconds=999;
var refNum:String=ref.text
if (any.selected)
{
refNum='%';
//wildcard
}
myService.getBranchData(from_date.selectedDate, toDateMod, branch.text, refNum);
}



Into coldfusion, to use in a mssql query, the log file shows that the date was changed

‘26/03/2009 12:00:00’

[Newsgroup_User]

nikos101 wrote:
> Into coldfusion, to use in a mssql query, the log file shows that the date was
> changed
>
> ?25/03/2009 12:00:00?

http://technet.microsoft.com/en-us/library/ms187819.aspx

Jochem


--
Jochem van Dieten
Adobe Community Expert for ColdFusion