Jump to content

How to only store time in visual basic and sql 2008

- - - - -
Started by WendyT, Jun 27 2009 05:51 AM

This topic has been archived. This means that you cannot reply to this topic.
3 replies to this topic

#1
WendyT
Posted 27 June 2009 - 05:51 AM

WendyT

    Newbie

  • Members
  • Pip
  • 6 posts
Hi everybody,

I wonder how can we store time only in SQL database through Visual Studio 2008? In Visual Studio 2008, when I use datetime, Visual Studio and SQL store the date and time together. However I only want to store time. Thanks for the help.

Wendy

#2
WingedPanther
Posted 27 June 2009 - 06:08 AM

WingedPanther

    A spammer's worst nightmare

  • Moderators
  • 16,831 posts
You can store the date portion as 12/31/1899. That allows you to ignore it in the application.
Programming is a branch of mathematics.
My CodeCall Blog | My Personal Blog

#3
WendyT
Posted 03 July 2009 - 08:29 AM

WendyT

    Newbie

  • Members
  • Pip
  • 6 posts
I have tried this trick, but when I display the data thru dataview, the date still appears there. Help me please somebody....

Wendy Tjan

#4
WingedPanther
Posted 03 July 2009 - 08:41 AM

WingedPanther

    A spammer's worst nightmare

  • Moderators
  • 16,831 posts
VB should have a way to change the display format. Since I'm not a VB programmer, I can't offer much more than that.
Programming is a branch of mathematics.
My CodeCall Blog | My Personal Blog
Back to Visual Basic Programming




  1. CODECALL Programming Forum
  2. → Software Development
  3. → Visual Basic Programming
IPB skins by Skinbox