7 messages in com.mysql.lists.win32Re: Formatting Question...
FromSent OnAttachments
Ryan Schefke19 Apr 2004 07:45 
Erich Dollansky19 Apr 2004 07:57 
Ryan Schefke19 Apr 2004 08:09 
Arthur Pelkey19 Apr 2004 08:13 
Erich Dollansky19 Apr 2004 08:15 
Ryan Schefke19 Apr 2004 08:21 
Arthur Pelkey19 Apr 2004 08:24 
Subject:Re: Formatting Question...
From:Erich Dollansky (ocea@pacific.net.sg)
Date:04/19/2004 07:57:41 AM
List:com.mysql.lists.win32

Hi,

Ryan Schefke wrote:

I have a drop down box that selects minutes, 01 through 59. When I use an insert query to add the minutes to the database (type char length 2) if the user selects 01 through 09 it adds it as 1,2,3,4, etc. How do I sustain the format to be 01, 02, 03, etc?

It depends on the programming language you use.

In general, I would right align the data before they are inserted into the database.

Erich