Add/Subtract Date/Time

[amanjsingh]

Hi,

I have a Database (MSSQL) with some tables having multiple Time columns (which I imported from some Access DB).

The DateTime format in the MSSQL is

1899-12-30 02:30:00.0

format. I populate my web forms using these columns (start time etc.) My problem is I cannot seem to add subtract time. I only need time part and I can use TimeFormat() function but I cannot seem to add time.

Can coldfusion deal with this format?

Thanks.

[acoder]

Use the DateAdd function to add/subtract date/time.

[amanjsingh]

Use the DateAdd function to add/subtract date/time.

Awesome! Thanks a lot.

[acoder]

You're welcome.