clark@xxxxxxxxxxxxx wrote: > Hi All Esteemed Developers, > > I have a requirement to have dates like ddmmmyyy. ie: 03MAR07 > > I want to be able to have dates returned from a query in this format > so that I can use passthrough queries from Access. I know I can use > to_char to format the date anyway I want, but this causes the column > to appear as a text datatype instead of a date datatype. Well, 03MAR07 is not a valid date. This is the formats we understand: http://www.postgresql.org/docs/8.2/static/datatype-datetime.html Joshua D. Drake > Any ideas? > > best regards, > billc > > > ---------------------------(end of broadcast)--------------------------- > TIP 4: Have you searched our list archives? > > http://archives.postgresql.org/ > -- === The PostgreSQL Company: Command Prompt, Inc. === Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240 Providing the most comprehensive PostgreSQL solutions since 1997 http://www.commandprompt.com/ Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate PostgreSQL Replication: http://www.commandprompt.com/products/
