473,405 Members | 2,261 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,405 software developers and data experts.

Date Problem in vb 2008 and MySql

hi! i have a textbox called txtbday in vb 2008 and date column bday in mysql.

if the txtbday has nothing the mysql date column bday should have an empty data, but instead it always do this default date " 0000-00-00 "

wat would be the best solution for this kind of problem?
Oct 18 '15 #1
0 971

Sign in to post your reply or Sign up for a free account.

Similar topics

1
by: Jason | last post by:
I have a form which ads a technician service ticket into mysql. The fields are tech name time spent service client name etc... I assumed that mysql was storing the date of each record...
2
by: Paul | last post by:
I am trying to insert a date into a mysql table but everytime I attempt it the date field is always empty. The field is of Date type and the date in code is in European format dd/mm/yyyy. ...
8
by: hugh webster | last post by:
MySql seems to only accept dates as 'yyyy-mm-dd'. How do I do that when the user might input dd/mm/yy, or d.m.yyyy (I'm in Europe)? I know I can do sscanf, or explode to rebuild the date string -...
2
by: Kun | last post by:
I have an html form that takes dates and inserts them into a mysql file. Currently, users have to type in dates in the yyyy-mm-dd format. As of now, this process works with the sql. However, I...
1
by: varun aggarwal | last post by:
Hi i am inserting the date in the mysql table using the php. I dont know but its not working, i know that the error is because of this only. I am getting the date input from the user(for example...
5
by: ajos | last post by:
hi friends, i imported my database from ms access to mysql, there is a problem though the date in mysql has the format (yyyy-mm-dd) and i want to change it to dd/mm/yyyy.how can i do it?i am using...
1
by: pravinkumar | last post by:
how to get last modified date in mysql database? is there any triggers?
8
code green
by: code green | last post by:
I am transfering data from a CSV file to a MySql database. Unfortunately the dates are in 2008.27.08 US string format instead instead of 2008-08-27 database format. The CSV data is first read into...
7
by: kkshansid | last post by:
i hav a dropdown list of date 1-31 month january-december year 2001-2009 i want to save it in musql database with dob field datatype date $month=$_POST; $date=$_POST; $year=$_POST;...
1
by: chand basha | last post by:
Hi, Can any one tell me how to set the default date in mysql query. i have some date base in that i need to run crone every day. But i need to run the crone only for this month. for ex i...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.