+ Reply to Thread
Results 1 to 4 of 4

Thread: How to only store time in visual basic and sql 2008

  1. 06-27-2009 08:51 AM #1
    WendyT
    WendyT is offline
    Newbie WendyT is an unknown quantity at this point
    Join Date
    May 2009
    Posts
    6

    How to only store time in visual basic and sql 2008

    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
    Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
    Reply With Quote Reply With Quote  
  2. 06-27-2009 09:08 AM #2
    WingedPanther
    WingedPanther is online now
    Super Moderator WingedPanther has much to be proud of WingedPanther has much to be proud of WingedPanther has much to be proud of WingedPanther has much to be proud of WingedPanther has much to be proud of WingedPanther has much to be proud of WingedPanther has much to be proud of WingedPanther has much to be proud of WingedPanther has much to be proud of WingedPanther's Avatar
    Join Date
    Jul 2006
    Age
    36
    Posts
    11,662
    Blog Entries
    57

    Re: How to only store time in visual basic and sql 2008

    You can store the date portion as 12/31/1899. That allows you to ignore it in the application.
    CodeCall Blog | CodeCall Wiki | Shareware
    Programming is a branch of mathematics.
    My CodeCall Blog | My Personal Blog
    Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
    Reply With Quote Reply With Quote  
  3. 07-03-2009 11:29 AM #3
    WendyT
    WendyT is offline
    Newbie WendyT is an unknown quantity at this point
    Join Date
    May 2009
    Posts
    6

    Re: How to only store time in visual basic and sql 2008

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

    Wendy Tjan
    Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
    Reply With Quote Reply With Quote  
  4. 07-03-2009 11:41 AM #4
    WingedPanther
    WingedPanther is online now
    Super Moderator WingedPanther has much to be proud of WingedPanther has much to be proud of WingedPanther has much to be proud of WingedPanther has much to be proud of WingedPanther has much to be proud of WingedPanther has much to be proud of WingedPanther has much to be proud of WingedPanther has much to be proud of WingedPanther has much to be proud of WingedPanther's Avatar
    Join Date
    Jul 2006
    Age
    36
    Posts
    11,662
    Blog Entries
    57

    Re: How to only store time in visual basic and sql 2008

    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.
    CodeCall Blog | CodeCall Wiki | Shareware
    Programming is a branch of mathematics.
    My CodeCall Blog | My Personal Blog
    Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
    Reply With Quote Reply With Quote  
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

     

Similar Threads

  1. Visual basic 2008 DB Oracle
    By foxbymariuss in forum Visual Basic Programming
    Replies: 0
    Last Post: 05-14-2009, 06:05 AM
  2. Basic Protection from SQL Injection
    By Affix in forum PHP Tutorials
    Replies: 16
    Last Post: 02-23-2009, 04:16 AM
  3. Visual Studio 2005 and Windows Vista
    By Jordan in forum General Programming
    Replies: 14
    Last Post: 01-10-2009, 02:39 PM
  4. very basic php and sql test
    By phpforfun in forum PHP Forum
    Replies: 34
    Last Post: 09-20-2008, 04:22 PM
  5. Executing SQL Server 2k DTS Package via Visual Basic
    By Joemama in forum Visual Basic Programming
    Replies: 0
    Last Post: 04-09-2007, 06:21 PM

Bookmarks

Bookmarks

     
        Algorithms and Data Structures

        Java tutorials

        Algorithms Forum

Posting Permissions

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

Forum Rules