|
Posted by Ivαn Sαnchez Ortega on 07/25/06 13:36
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Bob Sanderson wrote:
> I have a field in a database called DateRcvd. At present, it outputs in my
> report in the yyyy-mm-dd format. I would like it to display in the
> dd/mm/yy format. What is the easiest way to accomplish this?
Rely on the DB's date formatting functions. Something like:
select date_format( table.DateRcvd, '%y/%m/%d' ) as formatted_date from
table;
Please check your SQL DB manual for the exact syntax for those functions.
- --
- ----------------------------------
IvΓ‘n SΓ‘nchez Ortega -i-punto-sanchez--arroba-mirame-punto-net
Un ordenador no es un televisor ni un microondas, es una herramienta
compleja.
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.3 (GNU/Linux)
iD8DBQFExh5u3jcQ2mg3Pc8RAnR3AJ9HyyXYCrNFijuaLPdffeRuYzNBagCcCcNW
Xn0pEQgp9bdzIalxackv3RE=
=EF4e
-----END PGP SIGNATURE-----
Navigation:
[Reply to this message]
|