Insert Date into Database

Results 1 to 2 of 2

Thread: Insert Date into Database

  1. #1
    Sean Guest

    Default Insert Date into Database

    I tried to insert date and time into the database but always get this error: Syntax error in INSERT INTO statement.<BR><BR>How do I store the date/time into the database

  2. #2
    Rameesh Guest

    Default RE: Insert Date into Database

    If you use oracle or sql server as your back end you can follow the following syntax<BR>1.<BR>insert into emp vlaues(eno,ename,doj)<BR>insert into emp values(1,&#039suresh&#039,&#039 12-jan-99&#039)<BR>Using VB script u can format the date using the following function<BR><BR>" FormatDatetime "<BR><BR>before inserting date into database first format according to back end format then you execute your insert statement query with date values

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts