Thread: Variables/Functions (Date & Hour)

Hi everybody,

I am writing a few scripts using PHP+PostgreSQL and I have a single
question:

- 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.

See ya,

Marcelo Pereira

-- Remember that only God and Esc+:w saves.
        __
       (_.\           Marcelo Pereira       |
        / / ___                             |
       / (_/ _ \__    Matematica/99 - IMECC |
_______\____/_\___)___Unicamp_______________/

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