| Subject | Formatting Brazilian dates in triggers and stored procedures |
|---|---|
| Author | Roberto Carlos |
| Post date | 2009-07-29T16:51:23Z |
I am using Firebird 2.1.2.
How can I simulate Delphi's FormatDateTime('dd/mm/yyyy', Now) in triggers and stored procedures?
Is there a better solution than
Select
'This product was finished in ' ||
Right('00' || Extract(Day from DateField),2) || '/' ||
Right('00' || Extract(Month from DateField),2) || '/' ||
Extract(Year from DateField) ||'.' as InformationField
From MyTable ?
Thanks,
Roberto Carlos
How can I simulate Delphi's FormatDateTime('dd/mm/yyyy', Now) in triggers and stored procedures?
Is there a better solution than
Select
'This product was finished in ' ||
Right('00' || Extract(Day from DateField),2) || '/' ||
Right('00' || Extract(Month from DateField),2) || '/' ||
Extract(Year from DateField) ||'.' as InformationField
From MyTable ?
Thanks,
Roberto Carlos