Ask a Question related to Dreamweaver AppDev, Design and Development.
-
BillB #1
Date() in SQL Database
In Access I can set a default value in a date field by using Date(). How do
I do this in an SQL Server database.
Bill
BillB Guest
-
date database
hi communiy i have a question how can i read from the data base the date like this 9/12/05 in my flash form it reads like this sept 12 2005 i dont... -
inserting date into MySql Database
I am trying to insert the current date into a MySql database. I know that the date format for MySql is yyyy-mm-dd . So far I have tried to insert... -
Use a CFC to update a database with a date
Hi All, I am trying to input a date in a database field with the current date. The datefield is in one table and I only want the date to be inserted... -
Accessing database using a date
From time to time I access records in the database using a date and time field. My ISP has just upgraded from ColdFusion 5 to ColdFusion MX 6.1. My... -
converting date into database date format(newbie)
Hi! U can convert "8-Aug-03" into mysql date which requires yyyy-mm-dd format as below. <?php date("Y-m-d",strtotime("8-Aug-03")); ?> -
BillB #2 Date() in SQL database
In Access I can set a default value in a date field by using Date(). How do
I do this in an SQL Server database.
Bill
BillB Guest
-
CMBergin #3 Re: Date() in SQL database
GETDATE()
"BillB @gmail.com>" <bill.betournay<"spamTrap"> wrote in message
news:d0kr4e$2pb$1@forums.macromedia.com...do> In Access I can set a default value in a date field by using Date(). How> I do this in an SQL Server database.
>
> Bill
>
>
CMBergin Guest
-
BillB #4 Re: Date() in SQL database
Thank you
Bill
"CMBergin" <NoHarvestForYou@NoSpam.org> wrote in message
news:d0krbs$361$1@forums.macromedia.com...> GETDATE()
>
> "BillB @gmail.com>" <bill.betournay<"spamTrap"> wrote in message
> news:d0kr4e$2pb$1@forums.macromedia.com...> do>> In Access I can set a default value in a date field by using Date(). How>>> I do this in an SQL Server database.
>>
>> Bill
>>
>>
>
BillB Guest
-
Reply With QuoteSimilar Questions and Discussions
Posting Permissions
- You may not post new threads
- You may post replies
- You may not post attachments
- You may not edit your posts
