SQL-VB Interface

• sameernavare

  Grasshopper

  Points: 23

  More actions

  January 14, 2002 at 8:42 am

  #63982

  While inserting date into a SQL Server table from a form in Visual Basic, what to do to insert only time without date

• tpantazi

  Mr or Mrs. 500

  Points: 582

  More actions

  January 14, 2002 at 9:34 am

  #422157

  If you pass the date as a string with no time components and use a convert function in the inset statement, it will have no time value.

  Thom Pantazi

• gvphubli

  Old Hand

  Points: 361

  More actions

  January 15, 2002 at 12:04 am

  #422181

  one more way is use

  Format(date,"dd-mmm-yyyy") (function in VB)

  one more example....

  Format(form1.dtpSDate.Value, "dd-mmm-yyyy")

• Andy Warren

  SSC Guru

  Points: 119902

  More actions

  January 15, 2002 at 5:31 am

  #422188

  Both are valid, just depends on where is the best place. If you ALWAYS want the value to just be the time portion, I'd say do in a procedure. If sometimes yes and sometimes no, keep the proc inserting the date however is passed, do the formatting in the app.

  Andy

  Andy
  Connect with me on LinkedIn