| From: | Jeff Self <jocknerd(at)home(dot)com> |
|---|---|
| To: | Marcelo Pereira <gandalf(at)sum(dot)desktop(dot)com(dot)br> |
| Cc: | <pgsql-php(at)postgresql(dot)org> |
| Subject: | Re: Variables/Functions (Date & Hour) |
| Date: | 2001-12-14 18:19:37 |
| Message-ID: | Pine.LNX.4.31.0112141317240.11712-100000@mulder.self.hom |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-php |
On Fri, 14 Dec 2001, Marcelo Pereira wrote:
> - When the user include your entries, I want to save the `date' and the
> `hour' in the registry.
>
> For a single example:
>
> The registry could be:
>
> int C_COD(4);
> char C_NAME(25);
> char C_COMPANY(40);
> char C_TEXT(120);
> char C_DATE(10);
> char C_HOUR(5);
>
> So, the user supply the NAME, COMPANY name and the TEXT, so the C_DATE and
> C_HOUR have to be automagicly included.
>
> My question is: How can I retrieve the DATE and HOUR from the system and
> put them in variables ? So I can manage it and insert the whole registry
> in the database.
>
Forget the C_DATE and C_HOUR fields. Just have a field with type
timestamp. You can then build a function to parse the timestamp to give
you the date and the hour for your output.
--
Jeff Self
Powered by Debian GNU/Linux
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Marc Spitzer | 2001-12-17 02:01:06 | Re: persistent connections, AOLserver (Was: maybe Offtopic : |
| Previous Message | Marcelo Pereira | 2001-12-14 16:15:53 | Variables/Functions (Date & Hour) |