473,397 Members | 2,084 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,397 software developers and data experts.

Date fromat

Hi Team

Am using Asp.net and mySql in my project. I need to display the id number by using month and year. the format should by MMYY. Please help me in this regard.
Jun 10 '10 #1
1 1393
mwasif
802 Expert 512MB
Use MySQL's DATE_FORMAT() function.
Jun 17 '10 #2

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

Similar topics

6
by: yoshitha | last post by:
hi db : sql server 2000 lan : C#.net(ASp.Net) in my database table there are 2 fileds of data type datatime. in field 1 i'm storing date in field 2 i'm storing time.
3
by: rsutradhar_python | last post by:
How to subtract date which is stored in string variable? Example: date1="2006-01-10" date2="2005-12-15" date = date1 - date2 should give me 25 but problem is that date1 and date2 datatype is...
5
by: YardDancer | last post by:
Hi All, Does anybody have a routine for validating a date or DateTime entry in a textbox. I know i can use one of the DateTime.Parse(textbox.text) methods which would throw a Fromat...
0
by: oneplace | last post by:
I have the following script that use for the following after i have made my search for a name in my database. I select the name and it bring up this from with all the information of the person. It...
5
by: mkadasi | last post by:
i want to convert date from MM/dd/yyyy format to dd/MM/yyyy fromat and add 30 days to the new formatted date. Please reply soon.
0
by: sidle | last post by:
raw audio 0 fromat ?
2
by: cmdolcet69 | last post by:
If i format my date string to look like month,day,year when i look at the file created it will look like: Raw Data File 37 05 08 10 58 12 were the 37 comes from i dont know the 37 should be 09 ...
1
by: dentnick | last post by:
Hi, I am new to all this. I try to run a website which uses the php date function to display date and time. The problem is that i am from Greece. The only problem i have is with the months...
4
by: bscott | last post by:
I am creating a linked table into access using a .csv file. One of the columns is a date/time in the following format: "06-01-2010 06:10 AM ". When I import it as Data Type Date/Time, Access...
2
by: slenish | last post by:
Hello, Im having an issue right now where im trying to link two tables in a query based on the date and then output the results to a report. What I have is a form set up to where you enter a...
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
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
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
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
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
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
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...
0
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...

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.