Subject |
Re: leading zero |
From |
Mervyn Bick <invalid@invalid.invalid> |
Date |
Thu, 23 Apr 2015 22:43:49 +0200 |
Newsgroups |
dbase.getting-started |
On Thu, 23 Apr 2015 20:09:00 +0200, eric wu <ericwuu@hotmail.com> wrote:
> what is the best easy way to covert a number with leading zero ?
>
> f.e. setup length to 5 , convert 123 to '00123'
Ken has dealt with this one.
>
> the best easy to convert date {04/22/2015} to '2015-04-22'
transform(dtos(query1.rowset.fields["whatever"].value),"@R 9999-99-99")
Mervyn.
|
|