Go Back   CodeCall Programming Forum > Software Development > Visual Basic Programming
How to only store time in visual basic and sql 2008 How to only store time in visual basic and sql 2008
Register Blogs Search Today's Posts Mark Forums Read

Visual Basic Programming Discussion forum for Visual Basic, an event driven programming language and associated development environment from Microsoft for its COM programming model.

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 06-27-2009, 09:51 AM
Newbie
  
Join Date: May 2009
Posts: 6
WendyT is an unknown quantity at this point
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
  #2 (permalink)  
Old 06-27-2009, 10:08 AM
WingedPanther's Avatar
Super Moderator
  
Join Date: Jul 2006
Age: 36
Posts: 11,435
WingedPanther has much to be proud ofWingedPanther has much to be proud ofWingedPanther has much to be proud ofWingedPanther has much to be proud ofWingedPanther has much to be proud ofWingedPanther has much to be proud ofWingedPanther has much to be proud ofWingedPanther has much to be proud ofWingedPanther has much to be proud of
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
  #3 (permalink)  
Old 07-03-2009, 12:29 PM
Newbie
  
Join Date: May 2009
Posts: 6
WendyT is an unknown quantity at this point
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
  #4 (permalink)  
Old 07-03-2009, 12:41 PM
WingedPanther's Avatar
Super Moderator
  
Join Date: Jul 2006
Age: 36
Posts: 11,435
WingedPanther has much to be proud ofWingedPanther has much to be proud ofWingedPanther has much to be proud ofWingedPanther has much to be proud ofWingedPanther has much to be proud ofWingedPanther has much to be proud ofWingedPanther has much to be proud ofWingedPanther has much to be proud ofWingedPanther has much to be proud of
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

« Previous Thread | Next Thread »


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes
Linear Mode Linear Mode


Similar Threads
Thread Thread Starter Forum Replies Last Post
Visual basic 2008 DB Oracle foxbymariuss Visual Basic Programming 0 05-14-2009 07:05 AM
Basic Protection from SQL Injection Affix PHP Tutorials 16 02-23-2009 05:16 AM
Visual Studio 2005 and Windows Vista Jordan General Programming 14 01-10-2009 03:39 PM
very basic php and sql test phpforfun PHP Forum 34 09-20-2008 05:22 PM
Executing SQL Server 2k DTS Package via Visual Basic Joemama Visual Basic Programming 0 04-09-2007 07:21 PM


All times are GMT -5. The time now is 09:27 AM.


Contact Us - Programming Forum - Archive - Top

vBulletin v3.8.0 ©2010, Jelsoft Enterprises Ltd.


no new posts

LinkBacks Enabled by vBSEO 3.1.0