Re: [SQL] timestamptz - problems

2004-02-09 Thread Christopher Browne
Oops! [EMAIL PROTECTED] ("Mark Roberts") was seen spray-painting on a wall: > Hi im using 'timestamptz' in a function called: 'getdate' to enter > the start and finish time into a db field, however the date appears > to be inserted into the db in a random format, i wish for it to only > be entered

[SQL] timestamptz - problems

2004-02-09 Thread Mark Roberts
Hi im using 'timestamptz' in a function called: 'getdate' to enter the start and finish time into a db field, however the date appears to be inserted into the db in a random format, i wish for it to only be entered into the db as DD-MM- (European,UK). I understand this is probably a very simpl