•
•
•
•
What is DaniWeb IT Discussion Community?
You're currently browsing the MS SQL section within the Web Development category of DaniWeb, a massive community of 391,770 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 3,268 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Please support our MS SQL advertiser:
Views: 1913 | Replies: 2
 |
•
•
Join Date: Feb 2008
Posts: 31
Reputation: 
Rep Power: 1
Solved Threads: 1
Light Poster
how to get current date and then store it to database? Hi friends,
I'm creating a website for my college project.
on clicking submit button on the feedback form, i want to retrieve current date and then store it along with entered details in the MS SQL database.
I don't know how to do it.
Can you please help me?
I'm doing the project using JSP and html pages and am using netbeans and tomcat.
Please help...!!
I'm creating a website for my college project.
on clicking submit button on the feedback form, i want to retrieve current date and then store it along with entered details in the MS SQL database.
I don't know how to do it.
Can you please help me?
I'm doing the project using JSP and html pages and am using netbeans and tomcat.
Please help...!!
•
•
Join Date: Apr 2005
Location: Old Hampshire, Old England (LOL)
Posts: 11,937
Reputation:
Rep Power: 30
Solved Threads: 264
You could probably set the default field value for new records to Now() from within MS SQL
i know this works for ms access/asp.net
i know this works for ms access/asp.net
TRY MY SUGGESTIONS AT YOUR OWN RISK!
james.bennet1@ntlworld.com
james.bennet1@ntlworld.com
•
•
Join Date: Aug 2006
Location: Egypt
Posts: 759
Reputation:
Rep Power: 4
Solved Threads: 57
Master Poster
In column properties set default value = getdate()
B.Sc Computer Science, Helwan University
Microsoft Student Partner
Personal blog http://ramymahrous.blogspot.com/
Arabic technical blog http://fci-h-ar.blogspot.com/
English technical blog http://fci-h.blogspot.com/
Microsoft Student Partner
Personal blog http://ramymahrous.blogspot.com/
Arabic technical blog http://fci-h-ar.blogspot.com/
English technical blog http://fci-h.blogspot.com/
|
•
•
•
•
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
•
•
•
•
•
•
•
•
DaniWeb MS SQL Marketplace
Linear Mode
- how to get system date and store it in MSSQL? (JSP)
- Need some ideas on building an exam result database. Assistance appreciated. (Database Design)
- Inserting recurring event/appointment type using time and date range (PHP)
- Inserting alternating event/appointment type using time and date range (PHP)
- Storing if a user has viewed a post (Database Design)
- Breaking strings (PHP)
- Track the number of times a user logs in (ASP)
- how do i get the current time when i click a button? (ASP)
- help with pcOrion spyware scanner (Viruses, Spyware and other Nasties)
Other Threads in the MS SQL Forum
- Previous Thread: permission issues in sql server 2005
- Next Thread: configuring mySQL ODBC issue
