Question: The question is:

List of the `DW1_ tables` from the `USER_OBJECTS` with table names, creation date and time in ISO standard. 

that's what I have so far, but it does not work.

```
select table_name, to_char(create_date, 'yyyy-mm-dd') from all_tables 
where table_name like 'DW1%'
group by table_name;

```

It said create\_date is invalid identifier.

Can anyone help me with this question?

Answer: 
Is this what you're looking for?

```
select object_name, created 
from user_objects 
where object_name LIKE 'DW1%' 
    and object_type = 'TABLE';

```

[SQL Fiddle Demo](http://sqlfiddle.com/#!4/8c9a3/1)
```
select object_name, to_char(created, 'yyyy-mm-dd') AS created -- 'AS' is optional
  from user_objects 
 where object_name like 'EMP%' -- replace with your table
/

```